The information_schema.table_privileges view is what I usually use.=0D
=0D
Hope that helps,=0D
Regina=0D
=0D
-----Original Message-----=0D
From: pgsql-novice-owner@[EMAIL PROTECTED]
On Behalf Of Szentpali Janos=0D
Sent: Thursday, February 28, 2008 7:41 AM=0D
To: pgsql-novice@[EMAIL PROTECTED]
[NOVICE] Priviledges=0D
=0D
Hi!=0D
=0D
Is there a way to find out the priviledges that users have on a database =
=0D
object (table | view | sequence)? I am interested in doing it via =0D
queries and not the psql's \z mytable command.=0D
Thanks!=0D
=0D
-- =0D
Szentp=E1li J=E1nos=0D
=0D
=0D
---------------------------(end of
broadcast)---------------------------=0D
TIP 6: explain analyze is your friend=0D
-----------------------------------------=0D
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended=0D
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.=0D
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
