Thread: Viewing access privileges

How can one view all of the access privileges of one or more users?

That is, how can I check what I have GRANTed to whom?

Also, where can I look to find answers to questions such as "what is the
function that returns today's date for a default column value"?

Cheers and thanks,
Stephen Davies.


========================================================================
Stephen Davies Consulting                                            scldad@sdc.com.au
Adelaide, South Australia.                                             Voice: 61-8-82728863
Computing & Network solutions.                                     Fax: 61-8-82741015

Stephen Davies wrote:
>
> How can one view all of the access privileges of one or more users?
>
> That is, how can I check what I have GRANTed to whom?

Try this:
SELECT relname,relacl FROM pg_class WHERE relname !~ '^pg_';

--
Tim J Trowbridge                         trowbrid@writeme.com
Interested in my genealogy?          http://www.execpc.com/~trowbrid