ACLSPECIAL= LIBNAME Statement Option

Invokes special access to SPD Server resources in the server domain for a server user. The special privilege must already exist in the password database.

Valid in:	SPD Server LIBNAME Statement
Note:	Option for Access Control Lists (ACLs).

Syntax

Required Arguments

Details

Example

Syntax

ACLSPECIAL=YES | NO

Required Arguments

YES

invokes special access to all server resources in the domain. These privileges override normal ACL restrictions and enable the user to access the resources of other users, as well as to create or modify ACLs of other users.

NO

denies special access to all server resources in the domain. Access is evaluated based on the ACL security defined on each domain resource. This is the default value.

Details

Server user IDs are registered in a password database. The password database supports privilege levels that confer special privileges. All connections from the SASSPDS engine are made as a regular user, regardless of the privileges a server user has defined in the password database. The ACLSPECIAL= LIBNAME statement option invokes special privileges from the password database in the SAS session. If you specify ACLSPECIAL=YES and do not have special privilege in the database, the server returns an error.

Example

Invoke special privileges for TheBoss, to enable him to Read, Write, Alter, and Control all tables in the Conversion_Area domain. (The administrator has defined TheBoss as 'special'.)

libname mylib sasspds 'conversion_area'
   server=husky.5400
   user='theboss'
   prompt=yes
   aclspecial=yes ;

Last updated: February 8, 2017