Re: Using SQL users to open jdbc connections

[Prem Prakash Sharma]

Thanks it worked, I missed the conversion to upper case without the quotes

Regards,
Prem

On Thu, Jul 26, 2018, 10:52 PM aealexsandrov 
wrote:

> Hi,
>
> Could you please show the command how you create new users?
>
> 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).
>
> BR,
> Andrei
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Using SQL users to open jdbc connections

[aealexsandrov]

Hi,

Could you please show the command how you create new users? 

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

BR,
Andrei



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Using SQL users to open jdbc connections

[prem]

Hi,
Is there any way we can use the user created via ignite sql to open jdbc 
connections. i have an authorization enabled cluster and can use the ignite 
superuser to open new jdbc connections with IgniteJdbcThinDriver but any users 
i create with create user sql command doesn't seem to work, the application 
throws an invalid username or password error while obtaining a new jdbc 
connection. am i missing something in the process

Regards,
Prem