SPDO Procedure

SET ACLUSER Statement

Sets the user scope for subsequent ACL operations.

Interaction: Used in conjunction with the ADD ACL, DELETE ACL, LIST ACL, and MODIFY ACL statements to set the context for the ACL request.
Syntax
Required Argument
Details
Examples
Example 1: Assign the Scope to the Libref User
Example 2: Assign the Scope to Another User to Modify ACLs

Syntax

SET ACLUSER name;

Required Argument

name

specifies a user name or group name. The name must be registered in the password database.

Details

To perform an ACL operation on a resource, you must meet these criteria:
  • be the resource owner
  • be the ACL entry owner
  • have Control access to the ACL entry
  • have special privilege in the password database and specify ACLSPECIAL=YES in the LIBNAME statement.
In addition, you must specify the name of the ACL owner in the SET ACLUSER statement. The SET ACLUSER statement sets the context for the all subsequent ACL requests. If the SET ACLUSER statement is executed without specifying a user name, the default user is the USER= specified in the LIBNAME statement.

Examples

Example 1: Assign the Scope to the Libref User

libname mylib sasspds 'd2'
server=zztop.5162
user='prod1'
password='spds123'
IP=YES ;

proc spdo library=mylib ;
/* assign the scope to the libref user */
set acluser prod1 ;

Example 2: Assign the Scope to Another User to Modify ACLs

In this example, the ACLSPECIAL= option invokes special privilege for user Admin1 to enable Admin1 to modify an ACL owned by user Prod1. 
libname admin1d2 sasspds 'd2'
server=zztop.5162
user='admin1'
password='spds123'
ACLSPECIAL=YES
IP=YES ;
proc spdo library=admin1d2 ;
set acluser prod1 ;
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017