Exporting Data to Another Vertica Database encrypting password?
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?