how to create a role with no privileges?

Поиск
Список
Период
Сортировка
От Kynn Jones
Тема how to create a role with no privileges?
Дата
Msg-id CAFvQaj46YRj4PFfyJTigYeehN7Y04=oF2mquTUpCigPE3TbBPw@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to create a role with no privileges?
Список pgsql-general
How does one define the most limited role/user possible in PostgreSQL?

Ideally, this role would not be able to do *anything* at all.  In particular, this role would not be able to query meta-information about existing tables, functions, etc. with backslash commands such as \dt, \df.

(Of course, in practice such a role would not correspond to any real role.  Its purpose, rather, is to serve as the starting point for defining more realistic roles by selectively adding the fewest privileges possible).

TIA for any pointers!

kynn


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

Предыдущее
От: Arup Rakshit
Дата:
Сообщение: Re: collecting employees who completed 5 and 10 years in the current month
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: how to create a role with no privileges?