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