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?"
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 |