Re: revoke create table from a user

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: revoke create table from a user
Дата
Msg-id 20031108221350.GB26691@wolff.to
обсуждение исходный текст
Ответ на revoke create table from a user  ("bagley@traderonline.com" <bagley@traderonline.com>)
Ответы Re: revoke create table from a user  ("bagley@traderonline.com" <bagley@traderonline.com>)
Список pgsql-admin
On Fri, Nov 07, 2003 at 15:47:50 -0500,
  "bagley@traderonline.com" <bagley@traderonline.com> wrote:
> I am trying to revoke the create table privilege from a user in a
> database.
>
> I have revoked create on database and on the public schema, yet I can
> still create table as that user.  what else do I need to do?

Is that user a superuser? If you gave that user the ability to create
new users then they are a superuser and access controls don't apply
to them.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Volunteers Needed
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: About Postgres Db size