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

Paul A · Accepted Answer

grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

Paul A · Accepted Answer

grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

Paul A · Answer

grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

Paul A · Answer

grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

Paul A · Answer

grant SELECT on all tables in database DB1 to role MYROLE;

Paul A · Answer

grant SELECT on future tables in database DB1 to role MYROLE;

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 259 - SnowPro Core discussion

Suggested answer: C, D

0 comments