Обсуждение: BUG #8719: user creation including role does not work nor complain if in keyword is not specified
BUG #8719: user creation including role does not work nor complain if in keyword is not specified
От
andres.more@intel.com
Дата:
The following bug has been logged on the website:
Bug reference: 8719
Logged by: Andres More
Email address: andres.more@intel.com
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}
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.