has_table_privilege ( [ user name or oid, ] table text or oid, privilege text ) → booleanDoes user have privilege for table? Allowable privilege types are
SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, and MAINTAIN.FUNCTIONS / SYSTEM INFORMATION FUNCTIONS AND OPERATORS
has_table_privilege
Read PG 18 manual ↗Does user have privilege for table? Allowable privilege types are SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, and MAINTAIN.
Signatures & examples
Version history 2
- PG 16 → 17changed
- PG 12 → 13changed
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source