Re: how to create a role with no privileges?

Поиск
Список
Период
Сортировка
От Kynn Jones
Тема Re: how to create a role with no privileges?
Дата
Msg-id CAFvQaj54pafg67pfmst3bfeT6hv-=j7hL4r-t-EEpLN3dy+8Hg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how to create a role with no privileges?  (Francisco Olarte <folarte@peoplecall.com>)
Ответы Re: how to create a role with no privileges?  (David G Johnston <david.g.johnston@gmail.com>)
Список pgsql-general

On Tue, Jul 1, 2014 at 12:36 PM, Francisco Olarte <folarte@peoplecall.com> wrote:
Without seeing your actual commands, it's difficult to know about the
schema stuff...

Well, the "actual commands" is what the original question was asking for, since I really don't know how to do any of this (I find the documentation very unclear on the matter).  At any rate, what I tried was

    REVOKE ALL ON SCHEMA x FROM nopriv;
    REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA x FROM nopriv;

...replacing x by public, pg_catalog, and information_schema.

kynn

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: how to create a role with no privileges?
Следующее
От: AI Rumman
Дата:
Сообщение: Re: lock contention, need profiling idea