CONNECTION_PRIVILEGES
Applies to: Databricks SQL Databricks Runtime 13.3 LTS and above Unity Catalog only
INFORMATION_SCHEMA.CONNECTION_PRIVILEGES lists principals that have privileges on a connection.
Definition
The CONNECTION_PRIVILEGES
relation contains the following columns:
Name | Data type | Nullable | Standard | Description |
---|---|---|---|---|
GRANTOR |
STRING |
No | Yes | Principal that granted the privilege. |
GRANTEE |
STRING |
No | Yes | Principal to which the privilege is granted. |
CONNECTION_NAME |
STRING |
No | Yes | Catalog on which the privilege is granted. |
PRIVILEGE_TYPE |
STRING |
No | Yes | Privilege being granted. |
IS_GRANTABLE |
STRING |
No | Yes | Always NO . Reserved for future use. |
INHERITED_FROM |
STRING |
No | No | The ancestor relation that the privilege is inherited from. |
Constraints
The following constraints apply to the CONNECTION_PRIVILEGES
relation:
Class | Name | Column List | Description |
---|---|---|---|
Primary key | CATPRIVS_PK |
GRANTOR , GRANTEE , CONNECTION_NAME , PRIVILEGE_TYPE |
Unique identifier for the granted privilege. |
Foreign key | CATPRIVS_CATS_FK |
CONNECTION_NAME |
References CONNECTIONS |
Examples
> SELECT connection_name, grantee
FROM information_schema.connection_privileges;