01-19-2012 05:52 AM
I assign library (library is of oracle type) in autoexec sas code based on sas username stored in &sysuserid. Then every user have library with same name but that library look on their schema on oracle.
Is there way that SAS EG prompt each user to enter usernam/password?
Example: SAS user dbob has same username on ORACLE and have schema dbob and I want SAS library to connect to that schema with a prompt asking his username/password.