Hide vsql password

Use this forum to post any tips, lessons or examples from your experiences working with Vertica that you think may help out other users in our community!

Moderator: NorbertKrupa

Post Reply
ajay.kapur
Newbie
Newbie
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?

Thanks

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1741
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Hide vsql password

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

Hi,

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

Image

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

Post Reply

Return to “Vertica Tips, Lessons and Examples”

Who is online

Users browsing this forum: No registered users and 1 guest