"Gauthier, Dave" <dave.gauth...@intel.com> writes: > I'm trying to determine who has what privs for what tables. Couldn't find > any canned views for that (but may have missed it). Or is there a query that > can get this from the metadata somehow?
You could try using has_table_privilege() in a join between pg_class and pg_authid ... might be a bit slow though. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general