Re: Ignite authenticationEnabled queries

2020-06-26 Thread Ilya Kasnacheev
Hello! Make sure user's login is "in quotes", otherwise it will be case-insensitive, i.e. ALLCAPS login. Regards, -- Ilya Kasnacheev пт, 26 июн. 2020 г. в 05:02, marble.zh...@coinflex.com < marble.zh...@coinflex.com>: > thanks a lot, with statement works. > > Btw, created a new user , but

Re: Ignite authenticationEnabled queries

2020-06-26 Thread marble.zh...@coinflex.com
thanks a lot, with statement works. Btw, created a new user , but cannot connect to the instance, anything else need settle done? thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite authenticationEnabled queries

2020-06-25 Thread marble.zh...@coinflex.com
not works, still show error, ALTER USER "ignite" SET password 'abcdefg' ; SQL Error [1001] [42000]:

Re: Ignite authenticationEnabled queries

2020-06-25 Thread Ilya Kasnacheev
Hello! I have filed a ticket about this mismatch: https://issues.apache.org/jira/browse/IGNITE-13184 Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 13:48, Ilya Kasnacheev : > Hello! > > I'm sorry for earlier advice, the correct syntax is: > ALTER USER "ignite" WITH PASSWORD 'abcdefg' ; >

Re: Ignite authenticationEnabled queries

2020-06-25 Thread Ilya Kasnacheev
Hello! I'm sorry for earlier advice, the correct syntax is: ALTER USER "ignite" WITH PASSWORD 'abcdefg' ; Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 13:10, marble.zh...@coinflex.com < marble.zh...@coinflex.com>: > not works, still show error, > > ALTER USER "ignite" SET password

Re: Ignite authenticationEnabled queries

2020-06-25 Thread Ilya Kasnacheev
Hello! Try ALTER USER "ignite" SET PASSWORD 'NewPassword'. WRT grants, we do not have granular object in JDBC authentication currently, except by using a 3rd party security plugin. Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 06:11, marble.zh...@coinflex.com <

Ignite authenticationEnabled queries

2020-06-25 Thread marble.zh...@coinflex.com
Hi Guru, Enabled the authentication with below configuration, it is ok for jdbc thin client with ignite/ignite to connect to server, but found cannot change ignite's password, will say no this user. And created new user cannot access, and no where to grant priviledges, how can we go? thanks a