SPDO Procedure

Example 2: Using PROXY Statements to Get Information about Locking SPD Server Users

Features:

LIST USERS/LOCKING statement

SET USER/LOCKING statement

SHOWLIBNAMES statement

Details

Here are examples of proxy statements that an administrator might submit to get information about locking users. They are presented in an order that would be typical for an administrator who is gathering user proxy information before issuing proxy commands on the user’s behalf.
1. List all locking users for the server Sunburn 6100.This example uses the same libref as the previous example and submits the LIST USERS/LOCKING statement.
libname example sasspds
  host='sunburn'
  serv='6100'
  user='sassyl'
  passwd='abc123'
  aclspecial=YES;

proc spdo lib=example;
list users/locking;
Information similar to the following is written to the log: 
Users Currently Connected to the Record Level Proxy
SPDUserName  Client Login   Thread Id
----------------------------------------
ANONYMOU     SASTEST        7
TEST         SASTEST        8
2. Set the user and specify the thread ID.The code submits the SET USER/LOCKING statement to set the user to ANONYMOU and the thread ID to 7.
set user/locking anonymou threadid=7;
A message similar to the following is written to the log: 
NOTE: User ANONYMOU connected to record
level proxy operator port with thread=7.
3. List the active librefs for the locking user with the SHOWLIBNAMES statement. 
showlibname _all_;
The following output is written to the log: 
LIBREF(LOCKING):Pathname assigned=/bigdisk/test/qabig1/
LIBREF(LOCKING):ACL Owner=
LIBREF(LOCKING):ACL Defaults(R,W,A,C)=(Y,Y,Y,Y)
4. List the open tables in the locking libref.This code submits the SHOWLIBNAME LOCKING statement with the /DATA= _ALL_ option. Note that there is no need to specify a libref in the SHOWLIBNAME statement.
showlibname LOCKING/data=_all_;
A message similar to the following might be written to the log. There are currently no tables open for the locking user ANONYMOU. 
NOTE: No data sets currently opened for LIBREF LOCKING.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017