system schema permission
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2025 03:17 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2025 05:03 AM
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];
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2025 11:22 PM
IS there any alternative way of getting access?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 04:34 AM
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.

