Search

What is the best way to provide passwords to user accounts of RDBMS in Sqoop import/export commands?



We can use –password argument to provide password of user account but it is not secure. The -P argument (prompts for user password) will read a password from a console prompt ,and is the preferred method of entering credentials. Credentials may still be transferred between nodes of the MapReduce cluster using insecure means. The most secure way is to use, â€“password-file <file containing the password> method. Set authentication password in this file on the users home directory with 400 permissions.