ROUTINE_PRIVILEGES
December 13, 2024
Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above Unity Catalog only
INFORMATION_SCHEMA.ROUTINE_PRIVILEGES lists principals that have privileges on a routine in a catalog.
The rows returned are limited to the routines the user is privileged to interact with.
Note
Currently, users with the MANAGE
privilege on an object cannot view all grants for that object in the INFORMATION_SCHEMA
. Instead, the INFORMATION_SCHEMA
only shows grants their own grants on the object. This behavior will be corrected in the future.
Users with MANAGE
privilege can view all grants on an object using SQL commands or Catalog Explorer. See Manage privileges in Unity Catalog.
Definition
The ROUTINE_PRIVILEGES
relation contains the following columns:
Name |
Data type |
Nullable |
Standard |
Description |
---|---|---|---|---|
|
|
No |
Yes |
Principal who granted the privilege. |
|
|
No |
Yes |
Principal to which the privilege is granted. |
|
|
No |
Yes |
Catalog of routine on which the privilege is granted. |
|
|
No |
Yes |
Database of routine on which the privilege is granted. |
|
|
No |
Yes |
Schema unique (specific) name of routine on which the privilege is granted. |
|
|
No |
Yes |
Matches |
|
|
No |
Yes |
Matches |
|
|
No |
Yes |
Name of routine on which the privilege is granted. |
|
|
No |
Yes |
Privilege being granted. |
|
|
No |
Yes |
Always |
|
|
Yes |
No |
The ancestor relation that the privilege is inherited from. |
Constraints
The following constraints apply to the ROUTINE_PRIVILEGES
relation:
Class |
Name |
Column List |
Description |
---|---|---|---|
Primary key |
|
|
Unique identifier for the granted privilege. |
Foreign key |
|
|
References ROUTINES |