Page 1 of 1

Hide vsql password

Posted: Thu Oct 15, 2015 5:31 pm
by ajay.kapur
I have shell scripts that use VSQL command with user Id and password in plain text. I have to hide the user id, password and database name specified in the script. Is there a way in Vertica to accomplish this? Oracle has a password wallet that can be defined to hide this information. Is there a similar method in Vertica?


Re: Hide vsql password

Posted: Fri Oct 16, 2015 6:45 pm
by JimKnicely

Maybe the VSQL_USER, VSQL_PASSWORD and VSQL_DATABASE environment variable could help?

Refer to: ... sql|_____8

You can set these variables in the user's .bashrc, .bash_profile or .profile, depending on your requirements.

Re: Hide vsql password

Posted: Sat Oct 07, 2017 12:22 am
by luffy500

I just have one doubt. VSQL_USER, VSQL_PASSWORD and VSQL_DATABASE are environment variables right? How do we use it for multiple users? For eg, in Oracle we can create wallet for each user and use them in scripts. Is there a way to achieve the same in Vertica? :?: