You are using a cluster running Databricks Runtime 7.3 LTS and above.
A user tries to access an object in the database and gets a SecurityException error message.
Error in SQL statement: SecurityException: User does not have permission USAGE on database <databasename>
A new USAGE privilege was added to the available data access privileges. This privilege is enforced on clusters running Databricks Runtime 7.3 LTS and above.
Grant the USAGE privilege to the user-group.
- Login to the workspace as an admin user.
- Open a notebook.
- Run the following command:
%sql GRANT USAGE ON DATABASE <databasename> TO <user-group>;