From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ian Lawrence Barwick <barwick(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Re: Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: [DOCS] Small clarification in "34.41. schemata") |
Date: | 2013-09-10 02:27:26 |
Message-ID: | 1378780046.14736.3.camel@vanquo.pezone.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-hackers |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2013-09-11 01:03:32 | Re: old testlo example code |
Previous Message | Bruce Momjian | 2013-09-07 18:01:52 | Re: Re: Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: [DOCS] Small clarification in "34.41. schemata") |
From | Date | Subject | |
---|---|---|---|
Next Message | Noah Misch | 2013-09-10 02:28:47 | Re: [bug fix] strerror() returns ??? in a UTF-8/C database with LC_MESSAGES=non-ASCII |
Previous Message | Noah Misch | 2013-09-10 01:54:44 | Re: Re: [bug fix] strerror() returns ??? in a UTF-8/C database with LC_MESSAGES=non-ASCII |