Exporting Data to Another Vertica Database encrypting password?

davds

Vertica has a great function to export data to another Vertica database. but it has to hard code password in the sql. like: CONNECT TO VERTICA testdb USER dbadmin PASSWORD '' ON 'VertTest01',5433;

Has anything like oracle dblink, username and password was encrypting in db level vs in script level?
or how can encrypting password when we do export.

We can not use this in the script, it is against the company's security policy.

Anyone has the solution?

thanks

GoCougs

@davds said:
Vertica has a great function to export data to another Vertica database. but it has to hard code password in the sql. like: CONNECT TO VERTICA testdb USER dbadmin PASSWORD '' ON 'VertTest01',5433;

Has anything like oracle dblink, username and password was encrypting in db level vs in script level?
or how can encrypting password when we do export.

We can not use this in the script, it is against the company's security policy.

Anyone has the solution?

thanks

The password is set to ****** in the vertica logs and query table. I'm not sure if that helps with your case though