udt_privileges The view udt_privileges identifies
USAGE 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 under Section 36.58
for why); see
Section 36.57 for domain privileges.
Table 36.54. 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 | Always TYPE USAGE |
is_grantable | yes_or_no | YES if the privilege is grantable, NO if not |