Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)
Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)
To grant a role the privilege to select data from all current tables and any tables that will be created later in a schema, you need to use two commands: one for existing tables and one for future tables. The command 'grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE' grants the SELECT privilege on all current tables in the schema. The command 'grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE' ensures that the role will have the SELECT privilege on any tables that are created in the schema in the future.
Changing to C,D
Asking two separate things
A,C - You need Grant Usage before Grant Select. Grant Select will give you access to all current and future tables (without needing to specify future). Granting future is only when you need to restrict access to current tables.).
I think C, D
https://community.snowflake.com/s/article/How-to-grant-select-on-all-future-tables-in-a-schema-and-database-level
CD are correct
Correct Answer: C & D GRANT SELECT ON ALL TABLES IN SCHEMA <SCHEMA NAME> TO ROLE <ROLENAME>; GRANT SELECT ON FUTURE TABLES IN SCHEMA <SCHEMA NAME> TO ROLE <ROLENAME>; Source : https://docs.snowflake.com/en/sql-reference/sql/grant-privilege
They are asking for select only not modify so A will not be an answer, c & d os correct
Correct
A,D is the correct answer
break this down into 1. select data from all current tables (A) 2. any tables that will be created later in a schema (D)
changing to C,D
Answer--A,D