Hi,
In PostgreSQL, there are some grant privileges like grant on SEQUENCE, DATABASE, LANGUAGE, SCHEMA and DATABASE. I grant and revoke these privleges on my PostgreSQL on Windows and Linux OS. But once it is granted, how do I find out what user and role are granted with these privileges? I tried going through all the obvious view and system tables and looking for documentation on postgresql.com without any luck.
I used these three which are great for the rest of the privleges that I need to see in my database.
information_schema.table_privileges --privilges grant on table/view
information_schema.routine_privileges --prilviges grant on function
pg_roles --privilges granted on role.
If you know this, can you please respond to my post? I would greatly appreciate any help.
Sincerely,
Louis Lam
Guardium, Inc.