Re: Additional Grants To SuperUser? - Mailing list pgsql-general

From Carlos Mennens
Subject Re: Additional Grants To SuperUser?
Date
Msg-id AANLkTi=kq=2OUzHrsSsx2WFOn2u4S8m-a3_yBNOAb0HF@mail.gmail.com
Whole thread Raw
In response to Re: Additional Grants To SuperUser?  (Dmitriy Igrishin <dmitigr@gmail.com>)
Responses Re: Additional Grants To SuperUser?  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-general
On Fri, Feb 4, 2011 at 5:08 PM, Dmitriy Igrishin <dmitigr@gmail.com> wrote:
> These all (SUPERUSER, CREATEDB, SUPERUSER) are role attributes.
> By performing ALTER ROLE postgres NOSUPERUSER it is possible to
> turn role with a superuser status into a role that just can create databases
> and manage roles (admin, but without superuser privileges).

So is it very bad to alter ANY of the default role attributes granted
to the 'postgres' user? I don't know if removing role attributes from
him will have negative consequences to features / functional tasks of
the PostgreSQL server / client application(s).

pgsql-general by date:

Previous
From: akp geek
Date:
Subject: Re: postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests
Next
From: akp geek
Date:
Subject: Re: postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests