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:[EMAIL PROTECTED] Denmark Website : http://www.netpointers.com "Remember that there are no bugs, only undocumented features." -------------------------------------------------------------- > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Heni Lolov > Sent: Wednesday, June 19, 2002 10:17 AM > To: [EMAIL PROTECTED] > 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 > > --- [EMAIL PROTECTED] 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 > > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
