used with a data set name dsname, detailed information about the specified data set
table is displayed.
LIBNAME Proxy Command Examples
1. List all of the users for the server 'sunburn.6100':
LIBNAME example sasspds
host='sunburn'
serv='6100'
user='sassyl'
passwd='abc123'
aclspecial=YES;
PROC SPDO lib=example;
list users;
Users Currently Connected to SPD Server
UserName Pid Portno
----------------------------------------
SASSYL 17704 58382
SASSYL 17614 58298
SASSYL 17613 58293
ANONYMOU 17611 58288
ANONYMOU 17610 58283
2. Set the user to ANONYMOU and specify process ID (Pid) 17610:
set user anonymou 17610;
NOTE: User ANONYMOU connected to proxy operator port with pid=17610.
3. Show every LIBNAME for user ANONYMOU for this proxy:
showlibname _all_;
LIBREF(FOO):Pathname assigned=/bigdisk/test/qabig1_dev/
LIBREF(FOO):ACL Owner=
LIBREF(FOO):ACL Defaults(R,W,A,C)=(Y,Y,Y,Y)
4. Show all of the open tables in LIBNAME FOO:
showlibname FOO/data=_all_;
NOTE: No data sets currently opened for LIBREF FOO.
5. Show all of the accessible tables in LIBNAME FOO:
showlibname FOO/dump=_all_;
LIBREF(FOO):Dataset name=BIGX
LIBREF(FOO):ACL Owner=ANONYMOU
LIBREF(FOO):ACL Defaults(R,W,A,C)=(N,N,N,N)
LIBREF(FOO):Dataset name=X
LIBREF(FOO):ACL Owner=ANONYMOU
LIBREF(FOO):ACL Defaults(R,W,A,C)=(N,N,N,N)
LIBNAME Proxy Command Examples
211
Summary of Contents for Scalable Performance Data Server 4.5
Page 1: ...SAS Scalable Performance Data Server 4 5 Administrator s Guide...
Page 7: ...Part 1 Product Notes Chapter 1 SPD Server 4 5 Product Notes 3 1...
Page 8: ...2...
Page 12: ...6...
Page 63: ...Part 3 Migration Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility 59 57...
Page 64: ...58...
Page 70: ...64 Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility...
Page 72: ...66...
Page 76: ...70 Chapter 6 Using the SPD Server Name Server to Manage Resources...
Page 94: ...88 Chapter 7 Administering and Configuring SPD Server Using the SAS Management Console...
Page 98: ...92 Chapter 8 SPD Server SQL Query Rewrite Facility...
Page 116: ...110 Chapter 10 Configuring Disk Storage for SPD Server...
Page 128: ...122 Chapter 11 Setting Up SPD Server Parameter Files...
Page 154: ...148...
Page 198: ...192 Chapter 14 ACL Security Overview...
Page 212: ...206 Chapter 15 Managing SPD Server Passwords Users and Table ACLs...
Page 214: ...208...
Page 224: ...218 Chapter 16 SPD Server Operator Interface Procedure PROC SPDO...
Page 236: ...230 Chapter 18 SPD Server Table List Utility Spdsls...
Page 256: ...250 Chapter 19 SPD Server Backup and Restore Utilities...
Page 264: ...258 Chapter 20 SPD Server Directory Cleanup Utility...
Page 270: ......