Thread: Preventing users from creating tables in certain dbs.

Preventing users from creating tables in certain dbs.

From
Stefan Muehlebach
Date:
Hi there

How can I prevent a user from creating a table in a database that she is
not owner of?

Suppose we have two users: 'mary' and 'fred', both are postgres-users, NOT
allowed to create dbs or users. For both users the db manager already
created a database (named 'mary' and 'fred').

In the standard installation of postgres it is possible for 'mary' and
'fred' to create tables in the database of the other user. How can I
prevent this?

I use this at our school, where every student should be able to have her
own database, but not beeing able to 'pollute' the db of her neighbour.

Thank you in advance for you help.
[mju]


Re: Preventing users from creating tables in certain dbs.

From
R D
Date:
--- Stefan Muehlebach <muehlste@student.ethz.ch>
wrote:
> Hi there
>
> How can I prevent a user from creating a table in a
> database that she is
> not owner of?
>
You can't. But as far as I know it's worked on the
problem.

Rumen

p.s. Sorry if message is doubled but there was no
responce from pgsql-admin whole day!

__________________________________________________
Do You Yahoo!?
Send instant messages with Yahoo! Messenger.
http://im.yahoo.com/