proc access dbms=s2k accdesc=mylib.employee (alter=reward); create vlib.customer.view; select all; run;
Files
|
READ=
|
WRITE=
|
ALTER=
|
---|---|---|---|
access descriptor
|
no effect
|
no effect
|
protects descriptor
from being read or edited
|
view descriptor
|
protects DBMS data from being read or updated
|
protects DBMS data from being updated
|
protects descriptor
from being read or edited
|
proc datasets library=mylib memtype=access; modify employee (alter=reward); run;
proc datasets library=vlib memtype=view; modify custacct (read=mypw alter=mydept); run;
proc datasets library=vlib memtype=view; modify custacct (read=mypw/ alter=mydept/); run;
/* Assign passwords */ proc datasets library=vlib memtype=view; modify custinfo (read=r2d2 alter=c3po); run; /* Invalid password given */ proc print data=vlib.custinfo (pw=r2dq); where ssn = '178-42-6534'; title2 'Data for 178-42-6534'; run; /* Valid password given */ proc print data=vlib.custinfo (pw=r2d2); where ssn = '178-42-6534'; title2 'Data for 178-42-6534'; run;