Desktop productivity for business analysts and programmers

dynamically assigned library and prompt mode

Reply
Occasional Contributor
Posts: 5

dynamically assigned library and prompt mode

Hello,

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.

Ask a Question
Discussion stats
  • 0 replies
  • 122 views
  • 0 likes
  • 1 in conversation