Effective March 31st, we will no longer engage on PostgresRocks.
How to engage with us further?
- Thought Leadership: EDB Blogs
- Tips and Tricks: Postgres Tutorials
- Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket
- Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.
Re: What is the EDB equivalent of DBA_TAB_PRIVS?
The Postgres-way to check database, schema, and table privileges is to use the ACL (Access Contro List) column of the system views pg_database (databases), pg_namespace (schemas), and pg_class (tables, indexes, etc.). Therein you will find information about privileges granted to users in a codified format--a mapping can be found in the documentation. For your reference, it's also below:
rolename=xxxx -- privileges granted to a role =xxxx -- privileges granted to PUBLIC r -- SELECT ("read") w -- UPDATE ("write") a -- INSERT ("append") d -- DELETE D -- TRUNCATE x -- REFERENCES t -- TRIGGER X -- EXECUTE U -- USAGE C -- CREATE c -- CONNECT T -- TEMPORARY arwdDxt -- ALL PRIVILEGES (for tables, varies for other objects) * -- grant option for preceding privilege /yyyy -- role that granted this privilege
You may also need to cross-reference with pg_user/pg_group. Hope this helps!