Hide vsql password

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: 1768
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.

luffy500
Newbie
Newbie
Posts: 1
Joined: Fri Oct 06, 2017 11:28 pm

Re: Hide vsql password

Post by luffy500 » Sat Oct 07, 2017 12:22 am

Hi,

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? :?:

Post Reply

Return to “Vertica Tips, Lessons and Examples”