cancel
Showing results for 
Search instead for 
Did you mean: 
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Showing results for 
Search instead for 
Did you mean: 

system schema permission

PoojaD
New Contributor II

I've Databricks workspace admin permissions and want to run few queries on system.billing schema to get more info on billing of dbx. Getting below errror: 
[INSUFFICIENT_PERMISSIONS] Insufficient privileges: User does not have USE SCHEMA on Schema 'system.billing'. SQLSTATE: 42501
Also i don't want to have account admin permission , is there any alternative way to get access or scoped access to read pricing tables.

3 REPLIES 3

Alberto_Umana
Databricks Employee
Databricks Employee

Hi @PoojaD,

You should access an admin to get you access:

GRANT USE SCHEMA ON SCHEMA system.billing TO [Your User];
GRANT SELECT ON TABLE system.billing.usage TO [Your User];

IS there any alternative way of getting access?

Account Admin is trying to give me access by using above commands but getting below error;
PERMISSION_DENIED: User does not have MANAGE on Schema 'System.billing'
System Schema has been enabled.

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now