
Ultimate access to all questions.
A new user without access to the catalog or schema requests access to the customer table in the sales schema. The customer table contains sensitive information, so a view was created excluding sensitive columns, and SELECT access was granted to the view for the user. However, the user encounters an error stating the view does not exist when attempting to query it. What is the issue preventing the user from accessing the view, and how can it be resolved?
A
The user needs SELECT privileges on the underlying table.
B
The user must be added to a special group with access to PII data.
C
The user must be the owner of the view.
D
The user requires USAGE privilege on the Sales schema.
E
The user needs ADMIN privilege on the view.