CREATE TABLE in PUBLIC schema

From: Heni Lolov <hal_bg(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: CREATE TABLE in PUBLIC schema
Date: 2002-11-13 11:13:09
Message-ID: 20021113111309.50549.qmail@web21005.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2002-11-13 12:56:38 Re: gmake check runs just 13 tests instead of 77
Previous Message Bruce Momjian 2002-11-13 03:17:25 Re: gmake check runs just 13 tests instead of 77