Explanation:
When a user has SELECT privileges on a view but not on the underlying table, they cannot query the view. This scenario occurs if the grantor of the view's SELECT privilege is not the table's owner or if the user lacks SELECT privileges on the table. In this case, since Ross granted David the privilege to query the view but David lacks SELECT privileges on the sales table, Mike, the table's owner, must grant David the SELECT privilege on the sales table to resolve the issue.
Ultimate access to all questions.
No comments yet.
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.