Check for row level security and column masking

eballinger — Tue, 17 Dec 2024 14:50:50 GMT

Hi All,

We have sensitive tables and have applied row level security and column masking. I would like to build into our job a check to make sure these tables still have the row filters and column masks applied. This would help ensure these security filters are not accidently removed from the tables and that goes unnoticed.

Is there anyway to query this info in Python or SQL?

Thanks

Re: Check for row level security and column masking

Alberto_Umana — Tue, 17 Dec 2024 15:28:10 GMT

Hi @eballinger.

Have you tried using DESCRIBE TABLE EXTENDED on the table, that will give you details about filters applied to a table.

topic Check for row level security and column masking in Data Engineering

Check for row level security and column masking

Re: Check for row level security and column masking