On 07/02/2014 07:50 AM, Rich Shepard wrote:
On Wed, 2 Jul 2014, David G Johnston wrote:
or if you want to do it as part of creating a new user:
CREATE ROLE new_management_user
[other stuff here]
IN ROLE management;
http://www.postgresql.org/docs/9.2/interactive/sql-createrole.html
David,
I'll have to think deeply about what this is doing. Initially, I read it
as assigning a new user's role to an existing group's role; that's the
opposite of what I want.
If you want opposite then:
http://www.postgresql.org/docs/9.2/interactive/sql-createrole.html
ROLE role_name
The ROLE clause lists one or more existing roles which are
automatically added as members of the new role. (This in effect makes
the new role a "group".)
Thanks,
Rich
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
