Extra functionality to createuser

From: Christopher Browne <cbbrowne(at)gmail(dot)com>
To: PostgreSQL Mailing Lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Extra functionality to createuser
Date: 2013-09-26 17:04:16
Message-ID: CAFNqd5Vf5wjX0Pm+1n5mAwgrnNbk3KfUv09s1etMb4A332JRKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sitting on my todo list for a while has been to consider the idea of
adding a bit of additional functionality to createuser.

One of the functions of CREATE ROLE is to associate the role with
other roles, thus...

create role my_new_user nosuperuser nocreatedb login
IN ROLE app_readonly_role, app2_writer_role;

That isn't something that I can do using createuser; to do that, I
would need to submit two requests separately:

PGUSER=postgres createuser -D -S -l my_new_user
PGUSER=postgres psql -c "grant app_readonly_role, app2_writer_role
to my_new_user;"

I could certainly change over to using psql to do all the work, but it
would be rather nice if createuser had (say) a "-g" option which
allowed specifying the set of roles that should be assigned.

Thus, the above commands might be replaced by:
PGUSER=postgres createuser -D -S -l -g
app_readonly_role,app2_writer_role my_new_user

Would this be worth adding to the ToDo list?
--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ivan Lezhnjov IV 2013-09-26 17:15:25 Re: backup.sgml-cmd-v003.patch
Previous Message Robert Haas 2013-09-26 17:00:53 Re: Minmax indexes