Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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;
