On 8/16/07, Joshua_Kramer <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate