CREATE TABLE in PUBLIC schema

Поиск
Список
Период
Сортировка
От Heni Lolov
Тема CREATE TABLE in PUBLIC schema
Дата
Msg-id 20021113111309.50549.qmail@web21005.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: gmake check runs just 13 tests instead of 77  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: CREATE TABLE in PUBLIC schema  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi
I have just downloaded and installed PgSQL 7.3b5.
Unfortunately the same problem is still there. There
is no way to diallow creating tables in the database.
Every user is able to crete tables in every database.

So there is no much sence to disallow users to create
schemas when they can create tables. in fact the same
security problem remains if someone wants to fill your
database (respectively filesystem) with bulk.

I have waited for this feature since v 6.5 but I am very
dissaopinted.
Is this the new security ?!?

SO WILL THERE EVER BE POSSIBLE TO DISALLOW
OBJECT CREATION TO USERS AND TO GIVE THEM
ONLY READ ACCESS TO SOME OBJECTS IN A DB?

10x a lot!

Hal

__________________________________________________
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2

В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: gmake check runs just 13 tests instead of 77
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: gmake check runs just 13 tests instead of 77