The udt_privileges view provides information about USAGE privileges granted on user-defined types.
| Column name | Data type | Description |
|---|---|---|
grantor |
sql_identifier |
The name of the role that granted the privilege. |
grantee |
sql_identifier |
The name of the role to which the privilege was granted. |
udt_catalog |
sql_identifier |
The name of the current database containing the type. |
udt_schema |
sql_identifier |
The name of the schema containing the type. |
udt_name |
sql_identifier |
The name of the type. |
privilege_type |
character_data |
The type of the privilege. Always TYPE USAGE. |
is_grantable |
yes_or_no |
Specifies whether the privilege is grantable (YES) or not (NO). |