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

Question

Options

• Agrant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
• Bgrant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
• Cgrant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
• Dgrant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
• Egrant SELECT on all tables in database DB1 to role MYROLE;
• Fgrant SELECT on future tables in database DB1 to role MYROLE;

• A
  3% (1)
• B
  10% (4)
• C
  79% (31)
• E
  3% (1)
• F
  5% (2)

No community discussion yet for this question.