Re: Using SQL users to open jdbc connections

2018-07-26 Thread 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

2018-07-26 Thread 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/