Answer-first summary for fast verification
Answer: Has no effect by itself but is required to perform any action on the database
The USAGE privilege does not grant any abilities by itself. However, it is a necessary requirement to perform any action on a schema (database) object. This means that while it doesn't directly provide permissions, it must be granted before other privileges can be exercised. Reference: [Databricks Documentation on Object Privileges](https://docs.databricks.com/security/access-control/table-acls/object-privileges.html#privileges)
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the primary benefit of the USAGE privilege in the context of a Databricks SQL query like GRANT USAGE ON DATABASE sales_db TO finance_team?
A
Grants read access on the database
B
Provides full permissions on the entire database
C
Enables the ability to view database objects and their metadata
D
Has no effect by itself but is required to perform any action on the database
E
The USAGE privilege is not part of the Databricks governance model