Anvilogic high experimental other

Snowflake Grant Ownership [snowflake-database_query_history]

Transfers ownership of an object (or all objects of a specified type in a schema) from one role to another role. Role refers to either a role or a database role. OWNERSHIP is a special type of privilege that can only be granted from one role to another role; it cannot be revoked. For more details, see Overview of Access Control.

View Source

Detection Logic

select * from snowflake.account_usage.query_history where event_time > dateadd(hour, -2, sysdate()) and query_text ilike 'grant ownership%'

Field Validations

Loading…

Comments (0)

Loading comments...