Hide vsql password

Moderator: NorbertKrupa

Post Reply
Posts: 1
Joined: Thu Oct 15, 2015 4:42 pm

Hide vsql password

Post by ajay.kapur » Thu Oct 15, 2015 5:31 pm

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?


User avatar
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am

Re: Hide vsql password

Post by JimKnicely » Fri Oct 16, 2015 6:45 pm


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

Refer to:

http://my.vertica.com/docs/7.1.x/HTML/i ... sql|_____8

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


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Tips, Lessons and Examples”