Store DBMS Credentials

Store Shared Credentials

Note: These instructions apply to third-party servers that do not accept the credentials with which users initially log on to SAS clients. These instructions are also appropriate for providing seamless access to other servers that require credentials that are different from the credentials with which users initially log on to SAS clients.

Open (or create) the group that you will use to manage the shared DBMS account. For example, if you want all users to share the account, use the PUBLIC group.
On the General tab, click Accounts. Next to the Logins table, click to add a login.
- In the Domain column, select the authentication domain for the DBMS.
  
  Note: In the DBMS server metadata, the authentication domain is specified on the connection object.
- In the Stored User ID column, enter the DBMS user ID.
- In the Stored Password (Optional) column, store the DBMS password.
On the Members tab, make sure that everyone who needs to use the shared account is a member.
Save the group.

Store Individual Credentials

Follow the instructions in the preceding topic, but add the login to a user definition instead of a group definition.

Note: If a user has more than one available login in a particular authentication domain, the login that is closest to the user is used. If there is tie, you might not be able to predict which will be used. One example of a tie is when a user is a direct member of two groups and both groups have logins in the same authentication domain.

Last updated: February 22, 2018