Re: create table permission - Mailing list pgsql-admin

From Rasmus Mohr
Subject Re: create table permission
Date
Msg-id 910513A5A944D5118BE900C04F67CB5A0BFDE7@MAIL
Whole thread Raw
In response to create table permission  (bertdd@lumumba.luc.ac.be)
Responses Re: create table permission
List pgsql-admin
What 'bout:

REVOKE ALL ON "table_name" FROM PUBLIC;
GRANT ALL ON "table_name" TO "postgres";
GRANT SELECT ON "table_name" TO "select_user";

???

--------------------------------------------------------------
Rasmus T. Mohr            Direct  :             +45 36 910 122
Application Developer     Mobile  :             +45 28 731 827
Netpointers Intl. ApS     Phone   :             +45 70 117 117
Vestergade 18 B           Fax     :             +45 70 115 115
1456 Copenhagen K         Email   : mailto:rmo@netpointers.com
Denmark                   Website : http://www.netpointers.com

"Remember that there are no bugs, only undocumented features."
--------------------------------------------------------------

> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Heni Lolov
> Sent: Wednesday, June 19, 2002 10:17 AM
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] create table permission
>
>
> Hi,
>
> This is the nost stupid thing in PostgreSQL, but there is no
> CREATE TABLE
> privilege :(((((((
> Everybody CAN create tables. Unfortunately it will not be
> inplemented even in
> Pg 7.3 according to TODO list. The developers do not consider
> it as important
> feature. In my opinion this is the most obvious security hole
> in PostgreSQL.
> Really Stupid but FACT!!!!!
>
> HEY PEOPLE WILL YOU EVER FIX IT?
>
> Hal
>
> --- bertdd@lumumba.luc.ac.be wrote:
> > How can I give SELECT privileges to a table of a database
> without giving
> > CREATE TABLE privileges to that database ?
> >
> > Bert De Decker
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

pgsql-admin by date:

Previous
From: Heni Lolov
Date:
Subject: Re: create table permission
Next
From: Heni Lolov
Date:
Subject: Re: create table permission