pg_check_privileges
Check which database roles hold write privileges on tables. Reveals INSERT, UPDATE, DELETE, or TRUNCATE permissions so you can lock down any role missing privilege-layer defenses.
Instructions
Report any write privilege (INSERT/UPDATE/DELETE/TRUNCATE) the connected role actually holds on any table. An empty list is the expected, safe result — anything else means the privilege layer of defense is missing and the role should be locked down (see README.md), even though the protocol and session layers still hold on their own.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||