We do use the user= option, because we solve several problems in one step
- the userid used by the scheduler is the same on the production DB and on the SAS server
- we do not want our SAS batch jobs to be able to write to the production DB, so connecting with same userid is out of the question
- we want several developers on SAS to be able to have the same read access to the DB server, for development and testing
so we have a dedicated "SAS user" that is used by the scheduler user and the developers when connecting to the DB server; all those users have the same entries in the id_rsa files in their .ssh directory that correspond to the id_rsa.pub on the server.
Glad I could be of help.
... View more