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.