The AUTHDOMAIN= option enables you to avoid explicitly specifying a database user ID and password in a SAS program. You define an authorization domain in metadata and define the associated credentials in a metadata repository.  Then, you can simply reference the authorization domain in a LIBNAME statement or in the SQL procedure pass-through code, as shown in the following examples:

The SAS/ACCESS engine accepts the credentials as if the user specified them in the USER= and PASSWORD= options.

The authentication domain and the associated login definition must be stored in a metadata repository and the metadata server must be running in order to resolve the metadata object specification.

When you are running interactively, you can be prompted for connection properties. Prompting occurs when either METASERVER= or METAPORT= are not specified.  To avoid the prompt, you can use the following OPTIONS statement before using authdomain= option.

Operating System and Release Information