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.)
A.
grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
B.
grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
C.
grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
D.
grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
E.
grant SELECT on all tables in database DB1 to role MYROLE;
F.
grant SELECT on future tables in database DB1 to role MYROLE;
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
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.).
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
arpit_dataguy
Highly Voted 1 year, 10 months agoexamed11
Highly Voted 1 year, 8 months ago_yyukta
Most Recent 8 months, 2 weeks agoVenkataPhaniPavanKumar
9 months, 2 weeks agoAfzy
1 year agoMultiCloudIronMan
1 year, 3 months agoJtravismiller
1 year, 9 months agosailoo
1 year, 10 months agosailoo
1 year, 10 months agosailoo
1 year, 10 months agoApo1021
1 year, 10 months agoarpit_dataguy
1 year, 10 months agoRob__C
1 year, 11 months ago