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