| 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: | Whole Thread | Raw Message | 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 |