Message-ID: <1378780046.14736.3.camel@vanquo.pezone.net>
Subject: Re: Re: Privileges for INFORMATION_SCHEMA.SCHEMATA (was
 Re: [DOCS] Small clarification in "34.41. schemata")
From: Peter Eisentraut <peter_e@gmx.net>
To: Bruce Momjian <bruce@momjian.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Ian Lawrence Barwick <barwick@gmail.com>,
 pgsql-hackers@postgresql.org
Date: Mon, 09 Sep 2013 22:27:26 -0400
In-Reply-To: <20130907180152.GF11757@momjian.us>
References: 
 <CAB8KJ=g317u8GVyoi+E8cByOGVa+iNVsriTgC+XFA-k2wqpCTA@mail.gmail.com>
 <11650.1357782995@sss.pgh.pa.us> <510AD8E0.9020005@gmx.net>
 <20130907180152.GF11757@momjian.us>
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

On Sat, 2013-09-07 at 14:01 -0400, Bruce Momjian wrote:
> > >     pg_has_role(n.nspowner, 'USAGE')
> > >     OR has_schema_privilege(n.oid, 'CREATE, USAGE')
> > > 
> > > As things stand, a non-superuser won't see "public", "pg_catalog",
> > > nor even "information_schema" itself in this view, which seems a
> > > tad silly.
> > 
> > I agree it would make sense to change this.
> 
> Is this the patch you want applied?  The docs are fine? 

I have committed it with a documentation update.


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers