LIBNAME user1 sasspds 'onepath'
server=zztop.5162
user='user1'
password='spds123'
IP=YES ;
PROC PRINT data=user1.anonymous_table
(obs=10) ;
title
'user1 reading anonymous_table' ;
run ;
/* Tables created by user ID anonymous */
/* can have ACLs */
PROC SPDO library=john ;
/* assign who owns the ACL */
set acluser anonymous ;
/* The MODIFY statement sets an ACl so */
/* only user ID 'anonymous' can read */
/* the table */
add ACL anonymous_table ;
modify ACL anonymous_table /
anonymous=(y,n,n,n);
list ACL _all_;
quit ;
/* Now, only user ID 'anonymous' can */
/* read the table */
LIBNAME user1 sasspds 'onepath'
server=zztop.5162
user='user1'
password='spds123'
IP=YES ;
PROC PRINT data=user1.anonymous_table
(obs=10) ;
title
'user1 trying to read anonymous_table' ;
run ;
LIBNAME mary sasspds 'onepath'
server=zztop.5162
user='anonymous'
password='anonymous'
IP=YES ;
PROC PRINT data=mary.anonymous_table
(obs=10) ;
ACL Security Examples 173