The Vertica Database Forums

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

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.