Users named "ignite" cannot change their password?

classic Classic list List threaded Threaded
3 messages Options
李玉珏@163 李玉珏@163
Reply | Threaded
Open this post in threaded view
|

Users named "ignite" cannot change their password?

Hi,

Execute the following statement:

ALTER USER ignite WITH PASSWORD 'test123';

The error message is as follows:

SQL 错误 [1] [50000]: Operation failed
[nodeId=88b03674-04a4-44cb-bd42-8f2ed1e980ff,
opId=5b656f9fc61-7cd6fa68-ee67-49d4-aee8-60958f5584af, err=class
org.apache.ignite.internal.processors.authentication.UserManagementException:
User doesn't exist [userName=IGNITE]]

The password of other users can be changed.

jdk1.8.0,gridgain-community-8.7.6

ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Users named "ignite" cannot change their password?

Hello!

User names are case sensitive and bound by SQL rules, i.e.:

ALTER USER "ignite" WITH PASSWORD 'test123';

Regards,
--
Ilya Kasnacheev


ср, 4 сент. 2019 г. в 05:14, liyuj <[hidden email]>:
Hi,

Execute the following statement:

ALTER USER ignite WITH PASSWORD 'test123';

The error message is as follows:

SQL 错误 [1] [50000]: Operation failed
[nodeId=88b03674-04a4-44cb-bd42-8f2ed1e980ff,
opId=5b656f9fc61-7cd6fa68-ee67-49d4-aee8-60958f5584af, err=class
org.apache.ignite.internal.processors.authentication.UserManagementException:
User doesn't exist [userName=IGNITE]]

The password of other users can be changed.

jdk1.8.0,gridgain-community-8.7.6

aealexsandrov aealexsandrov
Reply | Threaded
Open this post in threaded view
|

Re: Users named "ignite" cannot change their password?

Hi,

In addition to Ilia answer, please read next page:

https://apacheignite-sql.readme.io/docs/create-user#section-description

BR,
Andrei

9/4/2019 11:47 AM, Ilya Kasnacheev пишет:
Hello!

User names are case sensitive and bound by SQL rules, i.e.:

ALTER USER "ignite" WITH PASSWORD 'test123';

Regards,
--
Ilya Kasnacheev


ср, 4 сент. 2019 г. в 05:14, liyuj <[hidden email]>:
Hi,

Execute the following statement:

ALTER USER ignite WITH PASSWORD 'test123';

The error message is as follows:

SQL 错误 [1] [50000]: Operation failed
[nodeId=88b03674-04a4-44cb-bd42-8f2ed1e980ff,
opId=5b656f9fc61-7cd6fa68-ee67-49d4-aee8-60958f5584af, err=class
org.apache.ignite.internal.processors.authentication.UserManagementException:
User doesn't exist [userName=IGNITE]]

The password of other users can be changed.

jdk1.8.0,gridgain-community-8.7.6