Re: schema access privs

On Tue, Apr 05, 2011 at 06:33:46PM +0530, Vibhor Kumar wrote:
>
> On Apr 5, 2011, at 6:07 PM, Ray Stell wrote:
>
> > On Tue, Apr 05, 2011 at 03:58:46PM +0530, Vibhor Kumar wrote:
> >>
> >> Following are details:
> >> postgres=UC/postgres+
> >> [user] [privs] /[ ROLE who granted privs.
> >
> > What's the logic for reporting the U priv twice?
>
> [public]=[access][ ROLE who granted privs]
>
> for public there will no username, its always =(equals to) followed by access/[Role who granted privs].

template1=# \pset expanded
Expanded display is on.
template1=# \dn+ information_schema
List of schemas
-[ RECORD 1 ]-----+---------------------
Name | information_schema
Owner | postgres
Access privileges | postgres=UC/postgres
| =U/postgres
Description |

>From this:

template1=# \pset expanded
Expanded display is off.
template1=# \dn+ information_schema
List of schemas
Name | Owner | Access privileges | Description
--------------------+----------+----------------------+-------------
information_schema | postgres | postgres=UC/postgres+|
| | =U/postgres |
(1 row)

I was reading 3 fields:

1. postgres=UC
2. postgres=U
3. postgres

which made no sense at all.