Terug naar Utils
Snowflake · View
privilege_changes
Alle GRANT en REVOKE statements, ongeacht de gebruikte rol. Inclusief mislukte pogingen. Biedt een volledig auditspoor van wijzigingen in rechten en toegang.
Bron: SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY · Latentie: ~45min
| Kolom | Beschrijving |
|---|---|
| date | Datum |
| user_name | Gebruiker |
| role_name | Gebruikte rol |
| query_type | GRANT of REVOKE |
| execution_status | SUCCESS, FAIL of INCIDENT |
| statement | Volledige querytekst |
Broncode
create_admin_views.sql
create or replace view privilege_changes
comment = 'GRANT and REVOKE statements with the user and role that executed them (source: SNOWFLAKE.ACCOUNT_USAGE)'
as
select start_time::date as date
, user_name
, role_name
, query_type
, execution_status
, query_text as statement
from snowflake.account_usage.query_history
where query_type in ('GRANT', 'REVOKE')
order by start_time desc;