SUPERUSER vs CREATEUSER causes foul 'code smell'

From: Joshua_Kramer <josh(at)globalherald(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: SUPERUSER vs CREATEUSER causes foul 'code smell'
Date: 2007-08-16 15:36:24
Message-ID: Pine.LNX.4.64.0708161134270.16729@home-av-server.home-av
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hello,

In the pg_users view - is there a way to differentiate between a role with
SUPERUSER priveleges, and a user who merely has the CREATEUSER flag?

If I want to create a role who can create other roles, but not have other
SUPERUSER priveleges - how can I do that?

Cheers,
-J

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rodrigo De León 2007-08-16 15:41:00 Re: SUPERUSER vs CREATEUSER causes foul 'code smell'
Previous Message Michael Glaesemann 2007-08-16 15:35:13 Re: SUPERUSER vs CREATEUSER causes foul 'code smell'