Re: Ignite user create/modify trouble
Vladimir, Taras, Please help to understand how to improve existing docs. Do you have any plans on addressing the documented and discussed limitations in regards the case sensitivity? -- Denis On Fri, Jun 8, 2018 at 9:48 AM, aealexsandrov wrote: > https://issues.apache.org/jira/browse/IGNITE-8756 > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
Re: Ignite user create/modify trouble
https://issues.apache.org/jira/browse/IGNITE-8756 -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Ignite user create/modify trouble
Hi, Documentation should be updated as for me to describe how it designed in SQL. I will file the issue. When you use SQL and require to create the user like TesT then just use quotes. Without quotes, you will create TEST. In case if you are going to change the password for TesT user via SQL then use quotes in ALTER command. Without quotes, this command will try to find TEST. When you using JDBC then username will not be case sensitive. BR, Andrei -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Ignite user create/modify trouble
Thanks Andrei, adding quotes and realizing that case matters made all of the difference. I did read the documentation around this but my impression was that a connection via JDBC should be case insensitive and that does not appear to be the case. From the documentation: /For instance, if test was set as a username then: You can use Test, TEst, TEST and other combinations from JDBC and ODBC. You have to use TEST as the username from Ignite's native SQL APIs designed for Java, .NET and other programming languages./ I took that to mean that since I am connecting via JDBC that the username is case insensitive. Am I just misunderstanding? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Ignite user create/modify trouble
Hi, When you create the user in quotes ("test") using SQL as next: CREATE USER "test" WITH PASSWORD 'test' It will be created as it was set (in this case it will be test) If you create the user without quotes (test) using SQL as next: CREATE USER test WITH PASSWORD 'test' then username will be stored in uppercase (TEST). The same situation with other DDL commands. So if you are going to change the password of the default user you should do next: ALTER USER "ignite" WITH PASSWORD 'test'; When you set the username in JDBC then there is no case transformation? Could you please re-test your cases using quotes as well? BR, Andrei -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/