|
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. |
