35.57. udt_privileges
The viewudt_privileges identifiesUSAGE privileges granted on user-defined types to a currently enabled role or by a currently enabled role. There is one row for each combination of type, grantor, and grantee. This view shows only composite types (see underSection 35.59 for why); seeSection 35.58 for domain privileges.
Table 35.55. udt_privileges Columns
| Name | Data Type | Description |
|---|---|---|
grantor | sql_identifier | Name of the role that granted the privilege |
grantee | sql_identifier | Name of the role that the privilege was granted to |
udt_catalog | sql_identifier | Name of the database containing the type (always the current database) |
udt_schema | sql_identifier | Name of the schema containing the type |
udt_name | sql_identifier | Name of the type |
privilege_type | character_data | AlwaysTYPE USAGE |
is_grantable | yes_or_no | YES if the privilege is grantable,NO if not |