pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Szymon Guz <mabewlun@gmail.com>
To: Kasia Tuszynska <ktuszynska@esri.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: postgres function does not handle PUBLIC - expected?
Date: Tue, 10 Aug 2010 21:56:37 +0200
Message-ID: <AANLkTimAwQwmscGHLLxmrRJ7Wpe5sdeK8pXtWOG3bi7E@mail.gmail.com> (raw)
In-Reply-To: <232B5217AD58584C87019E8933556D110211D1AF24@redmx2.esri.com>
References: <232B5217AD58584C87019E8933556D110211D1AE9F@redmx2.esri.com>
	<AANLkTi=oeOFdmMsr515Npgk_qupNX2BdUY60UyOg7O+8@mail.gmail.com>
	<232B5217AD58584C87019E8933556D110211D1AEDA@redmx2.esri.com>
	<AANLkTim+biVOvQyntTfSy+H_z1M58TPrLZtF8TrHvcsu@mail.gmail.com>
	<4C6164E50200002500034463@gw.wicourts.gov>
	<232B5217AD58584C87019E8933556D110211D1AF24@redmx2.esri.com>

2010/8/10 Kasia Tuszynska <ktuszynska@esri.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

view thread (13+ messages)  latest in thread

Message-ID: <AANLkTimAwQwmscGHLLxmrRJ7Wpe5sdeK8pXtWOG3bi7E@mail.gmail.com>
Permalink:  ../AANLkTimAwQwmscGHLLxmrRJ7Wpe5sdeK8pXtWOG3bi7E@mail.gmail.com/
Also on:    postgresql.org/message-id/AANLkTimAwQwmscGHLLxmrRJ7Wpe5sdeK8pXtWOG3bi7E@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: mabewlun@gmail.com, ktuszynska@esri.com, Kevin.Grittner@wicourts.gov
  Subject: Re: postgres function does not handle PUBLIC - expected?
  In-Reply-To: <AANLkTimAwQwmscGHLLxmrRJ7Wpe5sdeK8pXtWOG3bi7E@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox