You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ilya Kasnacheev (Jira)" <ji...@apache.org> on 2020/06/25 10:56:00 UTC
[jira] [Created] (IGNITE-13184) ALTER USER SET PASSWORD is valid
syntax but does not find user
Ilya Kasnacheev created IGNITE-13184:
----------------------------------------
Summary: ALTER USER SET PASSWORD is valid syntax but does not find user
Key: IGNITE-13184
URL: https://issues.apache.org/jira/browse/IGNITE-13184
Project: Ignite
Issue Type: Bug
Components: security, sql
Affects Versions: 2.8.1
Reporter: Ilya Kasnacheev
I have noticed the following:
{code}
1: jdbc:ignite:thin://localhost> ALTER USER "ignite" set password 'abcdefg' ;
Error: Failed to parse query. Пользователь "ignite" не найден
User "ignite" not found; SQL statement:
ALTER USER "ignite" set password 'abcdefg' [90032-197] (state=42000,code=1001)
{code}
The correct syntax is "WITH PASSWORD" but using "SET PASSWORD" does not cause parse error (like LIMIT PASSWORD or WHERE PASSWORD) would. It will report that user does not exist, which is false, and can probably throw an user off.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)