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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [Beginner Question]Is there way to test the postgres's kernel function?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: How to improve the performance of my SQL query？