Functions / System Information Functions And Operators

has_database_privilege

Does user have privilege for database? Allowable privilege types are CREATE, CONNECT, TEMPORARY, and TEMP (which is equivalent to TEMPORARY).

Reading PG 18current·documented in 25 of 27 versions, 7.3 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_database_privilege ( [ user name or oid, ] database text or oid, privilege text ) → boolean

Does user have privilege for database? Allowable privilege types are CREATE, CONNECT, TEMPORARY, and TEMP (which is equivalent to TEMPORARY).

Version history 4

12 → 13 changed
7.4 → 8.0 changed
7.3 → 7.4 changed
7.2 → 7.3 added

Definition snapshot: b7bd9cda · English manual source