Functions / System Information Functions And Operators

has_schema_privilege

Does user have privilege for schema? Allowable privilege types are CREATE and USAGE.

Reading PG 18current·documented in 25 of 27 versions, 7.3 to 20

Signatures & examples

has_schema_privilege ( [ user name or oid, ] schema text or oid, privilege text ) → boolean

Does user have privilege for schema? Allowable privilege types are CREATE and USAGE.

Version history 4

Definition snapshot: b7bd9cda · English manual source