Answer-first summary for fast verification
Answer: Kevin can grant access to the view because he owns both the view and the underlying table.
The correct statement is that Kevin can grant access to the view because he is the owner of both the view and the underlying table. In most database systems, the owner of an object has the authority to grant permissions on that object. Security admin privileges are not required for granting basic permissions like SELECT. Workspace admin privilege is irrelevant in this context. Although permissions on the underlying table might be necessary in some cases, Kevin's ownership of both objects allows him to grant select permission on the view without separately granting permissions on the table. The SELECT permission on the view will suffice for accessing the underlying table's data.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Kevin owns both the sales table and the regional_sales_vw view, which uses the sales table as its data source. He wants to grant SELECT privilege on the view regional_sales_vw to Steven, a new team member. Which statement is true?
A
Kevin cannot grant access to Steven because he lacks security admin privilege.
B
Kevin, despite being the owner, does not have ALL PRIVILEGES permission.
C
Kevin can grant access to the view because he owns both the view and the underlying table.
D
Kevin cannot grant access to Steven because he lacks workspace admin privilege.
E
Steven will also need SELECT access on the underlying table.
No comments yet.