A SERVICE OF

logo

Open as PDF
next previous
prodgrp=(y,y,y,y)
group1=(n,n,n,n)
group2=(n,n,n,n)
group3=(n,n,n,n)
group4=(n,n,n,n);
list ACL _all_ ;
run ;
/* Modify ACL for tables to be refreshed */
PROC SPDO library=d2 ;
/* set who owns the ACLs */
set acluser prod1 ;
/* Modify table ACL to revoke read and */
/* control by user IDs in same group, */
/* which prevents locks during table */
/* refreshes. */
modify ACL prod1_table /
prodgrp=(n,n,n,n);
/* Modify table ACL to allow the */
/* 'prod1' user ID to refresh the */
/* table. */
modify ACL prod1_table /
prod1=(y,y,y,y) ;
list ACL _all_;
/* refresh warehouse table(s) */
data d2.prod1_table ;
do i = 1 to 100 ;
output ;
end ;
run ;
PROC SPDO library=d2 ;
/* Assign who owns the ACLs */
set ACLUSER prod1 ;
/* Allow users and groups access to */
/* the domain again. */
modify ACL / LIBNAME
group1=(y,n,n,n)
group2=(y,n,n,n)
group3=(y,n,n,n)
group4=(y,n,n,n) ;
list ACL _all_ ;
ACL Security Examples 183