Preventing users from creating tables in certain dbs.

Поиск
Список
Период
Сортировка
От Stefan Muehlebach
Тема Preventing users from creating tables in certain dbs.
Дата
Msg-id Pine.GSO.4.02.10006161430140.1792-100000@raf18
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Rodney McDuff
Дата:
Сообщение: Re: users & groups
Следующее
От: Bruno Madeiro da Silva
Дата:
Сообщение: Installation