Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Which commands grant a role the privilege to SELECT from all existing and future tables 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;