cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
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

Rishabh264
Honored Contributor II

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.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.