SUPERUSER vs CREATEUSER causes foul 'code smell' - Mailing list pgsql-sql

From Joshua_Kramer
Subject SUPERUSER vs CREATEUSER causes foul 'code smell'
Date
Msg-id Pine.LNX.4.64.0708161134270.16729@home-av-server.home-av
Whole thread Raw
Responses Re: SUPERUSER vs CREATEUSER causes foul 'code smell'
Re: SUPERUSER vs CREATEUSER causes foul 'code smell'
Re: SUPERUSER vs CREATEUSER causes foul 'code smell'
List 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



pgsql-sql by date:

Previous
From: "Fernando Hevia"
Date:
Subject: Re: Problem with phone list.
Next
From: Michael Glaesemann
Date:
Subject: Re: SUPERUSER vs CREATEUSER causes foul 'code smell'