Re: [SQL] Viewing access privileges

From: "Tim J Trowbridge" <trowbrid(at)execpc(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Viewing access privileges
Date: 1999-01-16 19:24:22
Message-ID: 199901161924.NAA23658@earth.execpc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)writeme(dot)com
Interested in my genealogy? http://www.execpc.com/~trowbrid

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message WolfySu 1999-01-17 03:01:27 subscribe wolfy@gcq.com.tw
Previous Message Stephen Davies 1999-01-16 09:00:57 Viewing access privileges