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
Hide vsql password
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1800
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Hide vsql password
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.
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.

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Hide vsql password
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?
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?
