Postgres Pro
Downloads
Home   >   mailing lists

Re: Connect to db denied for superuser inherited by group - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Connect to db denied for superuser inherited by group
Date
Msg-id CAKFQuwZJ3Vf9ftUnr2oK5j+EO+vQ9ZwrhpfM-1oJ8Nwxk81JBw@mail.gmail.com
Whole thread Raw
In response to Re: Connect to db denied for superuser inherited by group  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
On Fri, Mar 16, 2018 at 7:52 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Stephen Frost <sfrost@snowman.net> writes:
> * Michael.Dietrich@swisscom.com (Michael.Dietrich@swisscom.com) wrote:
>> 2) User without superuser privileges uses a role with superuser rights (usage confirmed with SHOW current_role.)

> Please provide more details about what this step #2 actually means.

If you mean that you did "GRANT superuserrole TO nonsuperuser", this
does not make "nonsuperuser" into a superuser; it merely allows
"nonsuperuser" to use whatever ordinary privileges might've been
granted to "superuserrole".

​IOW, the privileges on the "CREATE ROLE" page are not inheritable - inheritance only applies to privileges that are GRANT'ed

David J.
​

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Connect to db denied for superuser inherited by group
Next
From: "Heinemann, Manfred (IMS)"
Date:
Subject: RE: Function search_path