Câu 353: SnowPro Core

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.)

1. A. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
2. B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
3. C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE; — đáp án hiện tại
4. D. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE; — đáp án hiện tại
5. E. grant SELECT on all tables in database DB1 to role MYROLE;
6. F. grant SELECT on future tables in database DB1 to role MYROLE;