Functions / System Information Functions And Operators

has_table_privilege

Does user have privilege for table? Allowable privilege types are SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, and MAINTAIN.

Reading PG 18current·documented in 26 of 27 versions, 7.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_table_privilege ( [ user name or oid, ] table text or oid, privilege text ) → boolean

Does user have privilege for table? Allowable privilege types are SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, and MAINTAIN.

Version history 5

16 → 17 changed
12 → 13 changed
7.4 → 8.0 changed
7.3 → 7.4 changed
7.1 → 7.2 added

Definition snapshot: b7bd9cda · English manual source