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.