From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #8719: user creation including role does not work nor complain if in keyword is not specified |
Date: | 2014-01-03 15:54:05 |
Message-ID: | 1388764445653-5785235.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
andres.more wrote
> The following bug has been logged on the website:
>
> Bug reference: 8719
> Logged by: Andres More
> Email address:
> andres.more@
> PostgreSQL version: 9.3.1
> Operating system: Amazon RDS
> Description:
>
> If I create a new user with an specific role it it not included unless IN
> is
> included. However without IN the statement does not throw an error.
>
>
> Amazon RDS postgres engine does not offer an admin user, but a light
> version
> called rds_superuser.
>
>
> CREATE USER sql_ro_user2 WITH ENCRYPTED PASSWORD 'sql_ro_password' ROLE
> rds_superuser LOGIN
>
>
> opscode_chef=> \du
> List of roles
> Role name | Attributes |
> Member of
> -----------------+------------------------------------------------+---------------------------------------------------------
> opscode_chef | | {}
> opscode_chef_ro | | {}
> opscodepgsql | Create role, Create DB |
> {rds_superuser}
> rds_superuser | Cannot login |
> {opscode_chef,opscode_chef_ro,sql_ro_user,sql_ro_user2}
> rdsadmin | Superuser, Create role, Create DB, Replication | {}
> sql_ro_user | | {}
> sql_ro_user2 | | {}
>
>
> CREATE USER sql_ro_user3 WITH ENCRYPTED PASSWORD 'sql_ro_password' IN ROLE
> rds_superuser LOGIN
>
>
> opscode_chef=> \du
> List of roles
> Role name | Attributes |
> Member of
> -----------------+------------------------------------------------+---------------------------------------------------------
> opscode_chef | | {}
> opscode_chef_ro | | {}
> opscodepgsql | Create role, Create DB |
> {rds_superuser}
> rds_superuser | Cannot login |
> {opscode_chef,opscode_chef_ro,sql_ro_user,sql_ro_user2}
> rdsadmin | Superuser, Create role, Create DB, Replication | {}
> sql_ro_user | | {}
> sql_ro_user2 | | {}
> sql_ro_user3 | |
> {rds_superuser}
Both ROLE and IN ROLE are valid command options for CREATE ROLE. RTFM for
more details. Your example shows that the two commands are working as
expected.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-8719-user-creation-including-role-does-not-work-nor-complain-if-in-keyword-is-not-specified-tp5785225p5785235.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | jodynickel | 2014-01-03 18:23:39 | BUG #8721: pg_wrapper unaware of configuration includes |
Previous Message | andres.more | 2014-01-03 14:14:20 | BUG #8719: user creation including role does not work nor complain if in keyword is not specified |