Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 3B8539FB488
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 19 Jan 2007 15:11:09 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 54211-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 19 Jan 2007 15:11:00 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from kcout03.prserv.net (kcout03.prserv.net [12.154.55.33])
	by postgresql.org (Postfix) with ESMTP id 9C6259FB487
	for <pgsql-sql@postgresql.org>; Fri, 19 Jan 2007 15:11:00 -0400 (AST)
Received: from kcbe02 (kcbe02.backbone.kan[10.254.3.142])
	by prserv.net (kcout03) with SMTP
	id <2007011919105920300mqa6de>; Fri, 19 Jan 2007 19:10:59 +0000
X-Originating-IP: [10.254.3.142]
From: paallen@attglobal.net
To: pgsql-sql@postgresql.org,
Subject: Permissions Query?
Date: Fri, 19 Jan 2007 19:11:00 +0000
X-Priority: 3
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Message-Id: <20070119191100.9C6259FB487@postgresql.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.083 tagged_above=0 required=5 tests=AWL, BAYES_50,
	MSGID_FROM_MTA_ID, NO_REAL_NAME
X-Spam-Level: **
X-Archive-Number: 200701/84
X-Sequence-Number: 27236

Hi all,

still working on dabo a bit. Thanks for all the
earlier suggestions, they are working well.

I now want to know if the user/role has permision
to the schema.table.

How do I query to pgsql to know what permissions a
particular user has on the table?

I was thinking something along the lines of a
query that maybe produces results like this.

schematable    p_select p_delete p_all p_update ..
public.tbl1       1        0       0      0
public.tbl2       1        1       1      1
public.tbl        0        0       0      1

I am intersted to see if I can filter what
tables/schemas are avaliable to the user to avoid
error messages due to permissions.
thanks,
Phil