"Gauthier, Dave" <dave.gauthier@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general