Hi,I ran below command to list out all privileges of objects if "mydb" schema. Actually, I want to know what are the permissions "user1" has on mydb schema. Could you please tell me how to do this?mydb=# select pc.relname, pc.relacl from pg_class pc, pg_namespace pn where pc.relnamespace=pn.oid and pn.nspname='mydb'; relname | relacl----------------------------------+----------------------------------------------- mylog | {postgres=arwdDxt/postgres,=arwdDxt/postgres} techtable | {postgres=arwdDxt/postgres,=ar/postgres} techtable_log | hrtable | {postgres=arwdDxt/postgres,=ar/postgres} hrtable_log |(5 rows)mydb=> select current_user; current_user-------------- user1(1 row)mydb=>Thanks, Dipti
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных