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;
To grant a role the privilege to select data from all current and future tables in a schema, two separate commands are needed. The first command grants the SELECT privilege on all existing tables within the schema, and the second command grants the SELECT privilege on all tables that will be created in the future within the same schema.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit