| 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: | Whole Thread | Raw Message | 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).
| 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 |