Re: Create role question - Mailing list pgsql-general

From Tom Lane
Subject Re: Create role question
Date
Msg-id 28894.1132505595@sss.pgh.pa.us
Whole thread Raw
In response to Create role question  (Joachim Wieland <joe@mcknight.de>)
List pgsql-general
Joachim Wieland <joe@mcknight.de> writes:
> So in effect, if you grant the CREATEROLE privilege, you automatically grant
> CREATEDB as well...

Not to mention a whole lot of other privileges.  CREATEROLE is pretty
nearly superuser from a what-can-you-do point of view.  It only disables
the ability to actively break the database system (eg by directly
modifying system catalogs).

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Implementing rounding rule in plpgsql
Next
From: Tino Wildenhain
Date:
Subject: Re: Mambo (CMS) & PostgreSQL