Re: Extra functionality to createuser - Mailing list pgsql-hackers

From Sameer Thakur
Subject Re: Extra functionality to createuser
Date
Msg-id CABzZFEt_KjPD7BYJzRp+dqCR+7gyGy4Ux1fjMpo728+vYpQAcA@mail.gmail.com
Whole thread Raw
In response to Re: Extra functionality to createuser  (Christopher Browne <cbbrowne@gmail.com>)
Responses Re: Extra functionality to createuser  (Sameer Thakur <samthakur74@gmail.com>)
Re: Extra functionality to createuser  (Christopher Browne <cbbrowne@gmail.com>)
List pgsql-hackers
Hello,
Tried to test this patch. Did the following
1. cloned from https://github.com/samthakur74/postgres
2. Applied patch and make install
3. created rolesapp_readonly_role,app2_writer_role
4. Tried createuser -D -S -l -g app_readonly_role,app2_writer_role
test_user got error: createuser: invalid option -- 'g'
5. Tried createuser -D -S -l --roles
app_readonly_role,app2_writer_role test_user. This does not give
error.
6. Confirmed that test_user is created using \du and it has
postgres=# \du                                              List of roles    Role name     |
Attributes                  |  Member of
 
-------------------+------------------------------------------------+-----------
---------------------------Sameer            | Superuser, Create role, Create DB, Replication | {}app2_writer_role  |
Cannotlogin                                   | {}app_readonly_role | Cannot login                                   |
{}my_new_user      |                                                | {app_reado
 
nly_role,app2_writer_role}test_user         |                                                | {app_reado
nly_role,app2_writer_role}

7. createuser --help does show  -g, --roles               roles to
associate with this new role

So i think -g option is failing

regards
Sameer



pgsql-hackers by date:

Previous
From: Marko Tiikkaja
Date:
Subject: Re: [PATCH] pg_basebackup: progress report max once per second
Next
From: Magnus Hagander
Date:
Subject: Re: [GENERAL] Clang 3.3 Analyzer Results