35.55. 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 column, grantor, and grantee. This view shows only composite types (see under Section 35.57 for why); see Section 35.56 for domain privileges.

Table 35-53. udt_privileges Columns

NameData TypeDescription
grantorsql_identifierName of the role that granted the privilege
granteesql_identifierName of the role that the privilege was granted to
udt_catalogsql_identifierName of the database containing the type (always the current database)
udt_schemasql_identifierName of the schema containing the type
udt_namesql_identifierName of the type
privilege_typecharacter_dataAlways TYPE USAGE
is_grantableyes_or_noYES if the privilege is grantable, NO if not