Re: Additional Grants To SuperUser?

From: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Additional Grants To SuperUser?
Date: 2011-02-07 17:41:06
Message-ID: AANLkTi=kq=2OUzHrsSsx2WFOn2u4S8m-a3_yBNOAb0HF@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 4, 2011 at 5:08 PM, Dmitriy Igrishin <dmitigr(at)gmail(dot)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).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message akp geek 2011-02-07 17:49:41 Re: postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests
Previous Message akp geek 2011-02-07 17:38:14 Re: postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests