Postgres Pro
Downloads
Home   >   mailing lists

Re: Grant all privileges to user on a database - Mailing list pgsql-general

From David G. Johnston
Subject Re: Grant all privileges to user on a database
Date
Msg-id CAKFQuwZAqTAcqbsC1vWT6rX4FX13ebLwqLURv6m0QeMOi-RguQ@mail.gmail.com
Whole thread Raw
In response to Re: Grant all privileges to user on a database  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [Beginner Question]Is there way to test the postgres's kernel function?
Next
From: Laurenz Albe
Date:
Subject: Re: How to improve the performance of my SQL query？