From: | Szymon Guz <mabewlun(at)gmail(dot)com> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | Kasia Tuszynska <ktuszynska(at)esri(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: postgres function does not handle PUBLIC - expected? |
Date: | 2010-08-10 19:49:38 |
Message-ID: | AANLkTin7V5=5zNpF7+FNxZ94qENj=WiE1v-VrWM1i1XH@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
2010/8/10 Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
> Szymon Guz <mabewlun(at)gmail(dot)com> wrote:
>
> > No, there is no PUBLIC default role in ANY rdbms. In PostgreSQL
> > there is PUBLIC schema, not role. In my PostgreSQL database there
> > wasn't any such role... but I'll check that now... ok, I've
> > checked, I've got 15 roles, none is names PUBLIC, what's more, I
> > don't have any roles that cannot login.
> >
> > run simple query: SELECT rolname FROM pg_roles; and check the
> > existence of the PUBLIC role.
>
> Yeah, it's automatically there in a shadowy sort of way. Try this,
> for example, in your cluster with no PUBLIC role:
>
> test=# revoke create on database test from public;
> REVOKE
> test=# grant select on pg_class to public;
> GRANT
>
>
well... surprisingly that works... does the public role exist in the SQL
standard? why it is not in the pg_roles table?
Szymon
From | Date | Subject | |
---|---|---|---|
Next Message | Kasia Tuszynska | 2010-08-10 19:50:03 | Re: postgres function does not handle PUBLIC - expected? |
Previous Message | Kevin Grittner | 2010-08-10 19:40:37 | Re: postgres function does not handle PUBLIC - expected? |