topic system schema permission in Administration & Architecture

system schema permission

PoojaD — Thu, 20 Feb 2025 11:17:21 GMT

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.

Re: system schema permission

Alberto_Umana — Thu, 20 Feb 2025 13:03:50 GMT

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];

Re: system schema permission

PoojaD — Fri, 21 Feb 2025 07:22:47 GMT

IS there any alternative way of getting access?

Re: system schema permission

PoojaD — Fri, 21 Feb 2025 12:34:01 GMT

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.