Answer-first summary for fast verification
Answer: The user requires USAGE privilege on the Sales schema.
The correct answer is that the user requires USAGE privilege on the Sales schema. This privilege does not grant any abilities by itself but is a necessary requirement to perform any action on a schema object. To resolve the issue, execute the following command: `GRANT USAGE ON SCHEMA sales TO user@company.com;`.
Author: LeetQuiz Editorial Team
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.
No comments yet.