0

With PostgreSQL 9.4 on linux centos 6.6.

I give a privilege to a user with something like :

ALTER DEFAULT PRIVILEGES FOR ROLE DBNAME_adm IN SCHEMA DBNAME_adm GRANT SELECT,INSERT,UPDATE,DELETE ON TABLES TO DBNAME_usr;

I need to have a SQL statement to find if this privilege is already ok or not. I did not find any table in pg_catalog nor information_schema which contains such an information.

Where can I find default privileges metadata ?

Improve this question

1 Answer 1

Reset to default
3

I find it by myself !

Tables to be parsed to have all metadata on ACL and privileges given by ALTER DEFAULT PRIVILEGES can be found in pg_catalog.pg_default_acl and pg_catalog.pg_namespace with the help of pg_catalog.pg_authid.

Some references :

Improve this answer
1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.