Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.