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

On 8/16/07, Joshua_Kramer <josh@globalherald.net> wrote:
> 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?

select * from pg_roles;

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

create role foo createrole login password 'foo';

See:
http://www.postgresql.org/docs/8.2/static/sql-createrole.html