Preventing users from creating tables in certain dbs. - Mailing list pgsql-admin

From Stefan Muehlebach
Subject Preventing users from creating tables in certain dbs.
Date
Msg-id Pine.GSO.4.02.10006161430140.1792-100000@raf18
Whole thread Raw
List pgsql-admin
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]


pgsql-admin by date:

Previous
From: Rodney McDuff
Date:
Subject: Re: users & groups
Next
From: Bruno Madeiro da Silva
Date:
Subject: Installation