On Thu, Feb 21, 2013 at 9:38 AM, bricklen <brick...@gmail.com> wrote: > A while back I was looking for a way to display object privileges > quickly with a bit better readibility. The following view is what I > came up with. Suggestions and improvements welcome (or comments > stating that there are much easi\er ways to get the same details).
The information schema exposes a lot of the same information, so it might be more portable to query from there rather than using the object_privileges view. Eg. for table privileges: select * from information_schema.table_privileges where table_name = 'event' limit 1; -[ RECORD 1 ]--+--------- grantor | postgres grantee | PUBLIC table_catalog | testdb table_schema | public table_name | event privilege_type | INSERT is_grantable | YES with_hierarchy | NO -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
