Hi,
if I run the code of my STP in EG the program runs without errors but embedded in a STP and via the
Stored Process Web Application I can the error "ERROR: The user does not have sufficient authority to access the data set files."
Why is that? The STP is set to run on the "Stored Process Server only". No specific user credentials are required. The data is not secret or specific for a particular user group. I also configured "allow execution on selected applications servers only" i.e, store source code in metadata. No result capabilities enabled (stream,package)
Code:
proc sql STIMER; connect to oracle as oracleadb (user=ADBS password='{SAS002}xxxxxxx' path=ADBS); create table SASxx.fact (COMPRESS=YES) as ( select * from connection to oracleadb ( select x from y ) /*connection close*/ ); disconnect from oracleadb; quit;
Bye
... View more