Showing results for 
Search instead for 
Did you mean: 

Verify the user's privileges on object level

Currently, it is not possible to list the user's privileges on object level in a particular database.


The privileges need to be checked from individual catalog table from the *acl column or using meta commands for respective objects. For example:


              Table :

           select relacl from pg_class where relname = 'test';
           \dt+ test

              Schema :


           select nspacl from pg_namespace where nspname = 'test';
           \dn+ test

             Tablespace :

           select spcacl from pg_tablespace where spcname = 'tblspc';
           \db+ tblspc


              Function :


           select proacl from pg_proc where proname = 'increment';
           \df+ increment

Please refer to a workaround shared in the below link[1], which makes use of the "Access privilege inquiry functions"[2]:



Version history
Revision #:
4 of 4
Last update:
‎05-23-2019 03:52 AM
Updated by:
Labels (4)