Explanation:
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
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