Hi Matijn, Thank you very much for the suggestion. I was able to figure this out yesterday by running this query to get the source code from the view then strip out the permission check and it work great. select * from pg_views where viewname = 'table_privileges' Thank you and Tom Lane for the help Louis. -----Original Message----- From: Martijn van Oosterhout [mailto:kleptog@xxxxxxxxx] Sent: Friday, June 05, 2009 1:18 PM To: Louis Lam Cc: Tom Lane; pgsql-general@xxxxxxxxxxxxxx Subject: Re: catalog view use to find DATABASE, LANGUAGE,TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role On Wed, Jun 03, 2009 at 01:46:00PM -0500, Louis Lam wrote: > So if I need to find out what table, view and function are granted to > user or role. I should be force to use pg_class and pg_proc? Unless > I can have superuser access? Use \dv+ on the information_schema view you want and copy the query. Take out the permission check and you're done. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
