How to prevent users from creating tables

Поиск
Список
Период
Сортировка
От raf
Тема How to prevent users from creating tables
Дата
Msg-id 20090204005222.GA19588@raf.org
обсуждение исходный текст
Ответы Re: How to prevent users from creating tables  ("Milen A. Radev" <milen@radev.net>)
Список pgsql-admin
hi,

in my database, normal users can't select, insert, update or
delete anything directly. they can only call functions which
are all security defining functions which give access to the
data. that's the way i like it.

however, i discovered that normal users can create new
tables in the database. is there any way to prevent this?
i couldn't find any grant/revoke syntax in the doco that
looked relevant.

cheers,
raf


В списке pgsql-admin по дате отправления:

Предыдущее
От: Lee Azzarello
Дата:
Сообщение: Re: Warm standby recovery failure
Следующее
От: "Daniel J. Summers"
Дата:
Сообщение: Re: Permissions to a schema