Re: Ignite authenticationEnabled queries
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 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
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
not works, still show error, ALTER USER "ignite" SET password 'abcdefg' ; SQL Error [1001] [42000]: Failed to parse query. User "ignite" not found; SQL statement: ALTER USER "ignite" SET password 'abcdefg' [90032-197] -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Ignite authenticationEnabled queries
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' ; > > 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 'abcdefg' ; >> >> >> >> >> SQL Error [1001] [42000]: Failed to parse query. User "ignite" not found; >> SQL statement: >> ALTER USER "ignite" SET password 'abcdefg' [90032-197] >> >> >> >> -- >> Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >> >
Re: Ignite authenticationEnabled queries
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 'abcdefg' ; > > > > > SQL Error [1001] [42000]: Failed to parse query. User "ignite" not found; > SQL statement: > ALTER USER "ignite" SET password 'abcdefg' [90032-197] > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
Re: Ignite authenticationEnabled queries
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 < 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 lot. > > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >