Redrock Postgres Search Chinese
Version: 9.3 / 9.4 / 9.5 / 9.6 / 10 / 11 / 12 / 13 / 14

36.56. 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

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