You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by liyuj <18...@163.com> on 2019/09/04 02:13:22 UTC

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


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

Posted by Andrei Aleksandrov <ae...@gmail.com>.
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 <18624049226@163.com 
> <ma...@163.com>>:
>
>     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
>

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

Posted by Ilya Kasnacheev <il...@gmail.com>.
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 <18...@163.com>:

> 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
>
>