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.
