User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?
User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?
To show all privileges granted to a specific schema, the appropriate command is 'SHOW GRANTS ON SCHEMA [database_name].[schema_name]'. Therefore, the command 'SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING' will display all privileges granted to the schema MARKETING in the ANALYTICS_DW database.
SHOW GRANTS ON DATABASE, WAREHOUSE, SCHEMA name
correct
Correct
https://docs.snowflake.com/en/sql-reference/sql/show-grants#variants