CREATE TABLE in PUBLIC schema - Mailing list pgsql-admin

From Heni Lolov
Subject CREATE TABLE in PUBLIC schema
Date
Msg-id 20021113111309.50549.qmail@web21005.mail.yahoo.com
Whole thread Raw
In response to Re: gmake check runs just 13 tests instead of 77  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: CREATE TABLE in PUBLIC schema  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: gmake check runs just 13 tests instead of 77
Next
From: Andrew Sullivan
Date:
Subject: Re: gmake check runs just 13 tests instead of 77