Functions / System Information Functions And Operators

has_type_privilege

Does user have privilege for data type? The only allowable privilege type is USAGE.

Reading PG 18current·documented in 16 of 27 versions, 9.2 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

has_type_privilege ( [ user name or oid, ] type text or oid, privilege text ) → boolean

Does user have privilege for data type? The only allowable privilege type is USAGE. When specifying a type by name rather than by OID, the allowed input is the same as for the regtype data type (see Section 8.19).

Version history 2

12 → 13 changed
9.1 → 9.2 added

Definition snapshot: b7bd9cda · English manual source