Options to Identify the SPD Server Client

ACLGRP=

Summary

Names an ACL group that has been previously assigned to the SPD Server user ID. The SPD Server system administrator sets up ACL groups and can assign a single user to up to five ACL groups.

Syntax

ACLGRP=aclgroup

Arguments

aclgroup

Names the ACL group that the SPD Server Administrator assigned to your SPD Server user ID. (You can be assigned up to five ACL groups.)

Example

Specify the ACL group PROD.

LIBNAME mylib sasspds 'spdsdata'
   user='receiver'
   aclgrp='PROD'
   prompt=yes;

Note: Password values are case sensitive. If the SPD Server administrator assigns a lowercase password value, you must enter the password value in lowercase.

AUTHDOMAIN=

Summary

Allows connection to a server by specifying the name of an authentication domain metadata object.

Syntax

AUTHDOMAIN=auth-domain

Arguments

auth-domain

name of an authentication domain metadata object.

Details

If you specify AUTHDOMAIN=, you must specify SERVER=. However, the authentication domain references credentials so that you do not need to explicitly specify USER= and PASSWORD=.

The syntax is

AUTHDOMAIN=MyServerAuth

.

An administrator creates authentication domain definitions while creating a user definition with the User Manager in SAS Management Console. The authentication domain is associated with one or more login metadata objects that provide access to the server and is resolved by the DBMS engine calling the SAS Metadata Server and returning the authentication credentials.

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.

Example

LIBNAME foo sasspds "spdsdata"
  host="hostname.na.companyname.com"
  serv="5400"
  AUTHDOMAIN=spds;

CHNGPASS=

Summary

Specifies whether to prompt an SPD Server user for a change of password. If ACL file security is enabled, SPD Server validates the old and new password against its user ID table.

Syntax

CHNGPASS= YES | NO

Arguments

YES

prompts for a change of the SPD Server user password.

NO

suppresses a prompt for a change of the SPD Server user password. This is the default.

Example

Specify a prompt to change the password of SPD Server user TEMPHIRE.

LIBNAME mylib sasspds 'spdsdata'
   user='temphire'
   password='whizbang'
   chngpass=yes;

Note: If you are using LDAP user authentication, and you create a user connection that uses the CHNGPASS= LIBNAME option, the user password will not be changed. If you are using LDAP authentication and want to change a user password, follow the operating system procedures to change a user password, and check with your LDAP server administrator to ensure that the LDAP database also records password changes.

NEWPASSWORD= or NEWPASSWD=

Summary

Specifies a new password for an SPD Server client user. If ACL file security is enabled, SPD Server validates the old or new password against its user ID table.

Syntax

NEWPASSWORD= newpassword
NEWPASSWD= newpassword

Arguments

newpassword

is the new password of an SPD Server client user. The password, visible in a SAS program, is encrypted in the SAS log file.

Example

Specify a new password rambo for SPD Server client user RECEIVER.

LIBNAME mylib sasspds 'spdsdata'
   user='receiver'
   password='whizbang'
   newpassword='rambo';

Note: If you are using LDAP user authentication, and you create a user connection that uses the NEWPASSWORD= LIBNAME option, the user password will not be changed. If you are using LDAP authentication and want to change a user password, follow the operating system procedures to change a user password, and check with your LDAP server administrator to ensure that the LDAP database also records password changes.

PASSWORD= or PASSWD=

Summary

Specifies the SPD Server password of an SPD Server client user. If ACL file security is enabled, SPD Server validates the password against its user ID table.

Syntax

PASSWORD='password'
PASSWD='password'

Arguments

'password'

is the case-sensitive password of an SPD Server client user. The password, visible in a SAS program, is encrypted in the SAS log file.

Example

Specify the password whizbang for SPD Server client user SPDSUSER.

LIBNAME mylib sasspds 'spdsdata'
   server=kaboom.5200
   user='spdsuser'
   password='whizbang';

Options

SPD Server 4.5 supports the integration of the SAS 9.2 PROC PWENCODE. This permits scripts to be generated that do not explicitly contain secure passwords that could easily be used without authorization. You must run PROC PWENCODE in Base SAS to enable the usage of script password encoding within SPD Server 4.5. See the Base SAS documentation for detailed instruction on running PROC PWENCODE for use with SPD Server 4.5.

The example below shows an SPD Server LIBNAME statement that uses the password encoding option:

LIBNAME mylib sasspds 'spdsdata'
   server=kaboom.5200
   user='spdsuser'
   password='{sas001}c3BkczEyMw==';

PROMPT=

Summary

Specifies whether to prompt an SPD Server user for a password. If ACL file security is enabled, SPD Server validates the password against its user ID table.

Syntax

PROMPT= YES | NO

Arguments

YES

prompts an SPD Server user for a password.

NO

suppresses a prompt for a password.

Example

Configure SPD Server to prompt SPD Server user BIGWHIG for a password.

LIBNAME mylib sasspds 'spdsdata'
   user='bigwhig'
   prompt=yes;

USER=

Summary

Specifies the ID of an SPD Server client user. If ACL file security is enabled, SPD Server validates the ID against its user ID table. (The SPD Server user ID defaults to the SAS process user ID if it is available, that is, when the client is not a Windows client.)

Syntax

USER='username'

Arguments

'username'

is the ID of an SPD Server client user.

Example

Specify the identifier SPDSUSER for an SPD Server client user.

LIBNAME mylib sasspds 'spdsdata'
  user='spdsuser'
  prompt=yes;