Re: create table permission
От | Rasmus Mohr |
---|---|
Тема | Re: create table permission |
Дата | |
Msg-id | 910513A5A944D5118BE900C04F67CB5A0BFDE7@MAIL обсуждение исходный текст |
Ответ на | create table permission (bertdd@lumumba.luc.ac.be) |
Ответы |
Re: create table permission
|
Список | 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 по дате отправления: