Question list
List of questions
Related questions
Question 140 - ARA-C01 discussion
Role A has the following permissions:
. USAGE on db1
. USAGE and CREATE VIEW on schemal in db1
. SELECT on tablel in schemal
Role B has the following permissions:
. USAGE on db2
. USAGE and CREATE VIEW on schema2 in db2
. SELECT on table2 in schema2
A user has Role A set as the primary role and Role B as a secondary role.
What command will fail for this user?
A.
use database db1; use schema schemal; create view v1 as select * from db2.schema2.table2;
B.
use database db2; use schema schema2; create view v2 as select * from dbl.schemal. tablel;
C.
use database db2; use schema schema2; select * from db1.schemal.tablel union select * from table2;
D.
use database db1; use schema schemal; select * from db2.schema2.table2;
Previous
Next
Your answer:
0 comments
Sorted by
Leave a comment first
