From: | Szymon Guz <mabewlun(at)gmail(dot)com> |
---|---|
To: | Kasia Tuszynska <ktuszynska(at)esri(dot)com> |
Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, "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:56:37 |
Message-ID: | AANLkTimAwQwmscGHLLxmrRJ7Wpe5sdeK8pXtWOG3bi7E@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
2010/8/10 Kasia Tuszynska <ktuszynska(at)esri(dot)com>
> Kevin,
> I know public is there from using it every day, but if it were not for you
> post I would not know how to prove it, none of the views, graphical admin
> tools etc. display it as a user.
>
> We found this issue because we can grant privs to public on a table, but
> could not revoke them. If I did not "know" that public was there ( because
> in my experience it is there in oracle, sql server and the Informix dbs) how
> would I check for it's existence on Postgres?
>
> Thank you,
> Kasia
"The key word PUBLIC refers to the implicitly defined group of all roles."
http://www.postgresql.org/docs/8.4/static/sql-revoke.html
<http://www.postgresql.org/docs/8.4/static/sql-revoke.html>So PUBLIC seems
to be a kind of magical role. I didn't know that, sorry for my previous, a
little bit confusing email.
regards
Szymon
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-08-10 20:00:29 | Re: postgres function does not handle PUBLIC - expected? |
Previous Message | Kasia Tuszynska | 2010-08-10 19:50:03 | Re: postgres function does not handle PUBLIC - expected? |