Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 78FAC6502F6 for ; Fri, 11 Jul 2008 09:38:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10998-07 for ; Fri, 11 Jul 2008 09:38:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web53702.mail.re2.yahoo.com (web53702.mail.re2.yahoo.com [206.190.37.23]) by postgresql.org (Postfix) with SMTP id D807964FFD8 for ; Fri, 11 Jul 2008 09:38:51 -0300 (ADT) Received: (qmail 60698 invoked by uid 60001); 11 Jul 2008 12:38:49 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Message-ID; b=ljErdPeGCXofGDrhTWXS2GigcuGhY+OfSk/D2DtK4KKGzSIFG3ESLBk7x0tp6+Zfe5gpnMuQRzujLKpxcHvSDpKVJZdRwot/7P2RbcdokqDxXc8KGYwaGWSNbX98nskfgPj3Qzauy1FLSvEHUtdIhvEJEEby78px1tIRWiArqBc=; Received: from [82.182.120.68] by web53702.mail.re2.yahoo.com via HTTP; Fri, 11 Jul 2008 05:38:49 PDT X-Mailer: YahooMailWebService/0.7.199 Date: Fri, 11 Jul 2008 05:38:49 -0700 (PDT) From: Dev Reply-To: dev_hyd2001@yahoo.com Subject: Access rule listing from the whole database cluster To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1120857462-1215779929=:59257" Message-ID: <448146.59257.qm@web53702.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.443 tagged_above=0 required=5 tests=AWL=0.442, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200807/113 X-Sequence-Number: 29723 --0-1120857462-1215779929=:59257 Content-Type: text/plain; charset=us-ascii Hi, Is there any way in Postgres to get a list of all the databases and tables which are readable( Select granted ) for a particular user with a single SQL query ? I'm able to get information of all the databases on the cluster owned by a user from the pg_database and pg_roles structures. I'm also able to get acls granted in a particular database table using information_schema.role_table_grants. Is it possible to do this kind of querying across all databases hosted on the cluster without having to connect to each and query them. ? /Dev --0-1120857462-1215779929=:59257 Content-Type: text/html; charset=us-ascii
Hi,

Is there any way in Postgres to get a list of all the databases and tables which are readable( Select granted ) for a particular user with a single SQL query ? I'm able to get information of all the databases on the cluster owned by a user from the pg_database and pg_roles structures. I'm also able to get acls granted in a particular database table using information_schema.role_table_grants. Is it possible to do this kind of querying across all databases hosted on the cluster without having to connect to each and query them. ?


/Dev

--0-1120857462-1215779929=:59257--