Re: Grant all privileges to user on a database

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Grant all privileges to user on a database
Дата
Msg-id CAKFQuwZAqTAcqbsC1vWT6rX4FX13ebLwqLURv6m0QeMOi-RguQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Grant all privileges to user on a database  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Mon, Jul 24, 2023 at 7:52 AM Ron <ronljohnsonjr@gmail.com> wrote:
On 7/24/23 09:09, Tom Lane wrote:

> GRANT ALL ON SCHEMA public TO public;

I'd have naively expected "GRANT ALL ON SCHEMA public TO public; " to be
taken care of by "GRANT ALL PRIVILEGES ON DATABASE cbdevdb TO cbdevdbadmin;".


I'm quite happy that such a command doesn't go ahead and grant read, write, and execute privileges on every table, function, and view in the database.

The thing that does what you describe is called SUPERUSER.

David J.

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