cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

What is the purpose of the USAGE privilege?

hello_world
New Contributor III

I watched a couple of courses on Databricks Academy, none of which clearly explains or demonstrates the purpose of the USAGE privilege.

USAGE: does not give any abilities, but is an additional requirement to perform any action on a schema object.

I have many questions about this statement.

  1. By "any action", does it mean CREATE and DROP a schema? How about other actions for instance SHOW and DESCRIBE?
  2. By "on a schema object", does it mean I do not need USAGE if I am only to perform CREATE, DROP, and SELECT on table objects? Or do I still need it considering tables are under schemas?
  3. Similar to question 2, do I need USAGE if all operations will be on the catalog level?
  4. Lastly, why does Databricks have USAGE? It sounds to me just overcomplicates the hierarchy.

1 REPLY 1

Rishabh-Pandey
Esteemed Contributor

hey @S L​ ​ I also have these questions , and what i get to know that usage is the minimum and mandot requirement which individual should have to perform any actions , that does not mean that you can do any actions by only usage permission , usage is the required permisson with any other permissons . simple if you want to perform drop , show and other actions you should also have a usage permisson.

Rishabh Pandey

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group