Answer-first summary for fast verification
Answer: Needs SELECT permission only on the VIEW
The data engineer already has USAGE permissions on the catalog and schema, allowing them to discover objects in those containers. To access a view, the engineer needs SELECT permission on the view itself. In Databricks Unity Catalog, when querying a view, the user does not require direct permissions on the underlying tables if the view's owner (sales team) has the necessary privileges. The view executes under the owner's permissions, so the engineer only needs SELECT permission on the view.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are the minimum additional permissions required for a data engineer to access a view created by the sales team on a shared cluster, given they already have usage permissions on the catalog and schema?
A
Needs SELECT permission on the VIEW and the underlying TABLE.
B
Needs SELECT permission only on the VIEW
C
Needs ALL PRIVILEGES on the VIEW
D
Needs ALL PRIVILEGES at the SCHEMA level
No comments yet.