Postgres Pro
Downloads
Home   >   mailing lists

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'  (Michael Glaesemann <grzm@seespotcode.net>)
Re: SUPERUSER vs CREATEUSER causes foul 'code smell'  ("Rodrigo De León" <rdeleonp@gmail.com>)
Re: SUPERUSER vs CREATEUSER causes foul 'code smell'  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
Tree view 
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'