Which of the following is a true statement?

Kevin is the owner of both the sales table and regional_sales_vw view which uses the sales table as the underlying source for the data, and Kevin is looking to grant select privilege on the view regional_sales_vw to one of newly joined team members Steven.

Which of the following is a true statement?
A . Kevin can not grant access to Steven since he does not have security admin privilege
B. Kevin although is the owner but does not have ALL PRIVILEGES permission
C. Kevin can grant access to the view, because he is the owner of the view and the under-lying table
D. Kevin can not grant access to Steven since he does have workspace admin privilege
E. Steve will also require SELECT access on the underlying table

Answer: C

Explanation:

The answer is, Kevin can grant access to the view, because he is the owner of the view and the un-derlying table,

Ownership determines whether or not you can grant privileges on derived objects to other users, a user who creates a schema, table, view, or function becomes its owner. The owner is granted all privileges and can grant privileges to other users

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments