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

34.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 34.57 for why); see Section 34.56 for domain privileges.

Table 34-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