
Ultimate access to all questions.
Mike is the current owner of the sales table. He granted Ross the privilege to create a view named regional_sales_vw. After creating the view, Ross granted David the privilege to query the view. However, David encounters an error when attempting to access the view. What steps can be taken to resolve this issue?
A
Ross must transfer ownership of the sales table from Mike to himself.
B
David needs to become the owner of the regional_sales_vw view to access it.
C
Mike must grant David the SELECT privilege on the sales table.
D
David must own the sales table to access the regional_sales_vw view.
E
Ross should grant David the SELECT privilege on the sales table.