Dear SAS Experts,
We got a STP running daily. It created a dataset in SAS BASE library X.
I want to do the same with library Y. A different stored process, a different SAS BASE library.
The sassrv user has access to write in the library folder.
the error reads (translated from German):
ERROR: user does not have required access to file Y.P15_SEL.DATA.
Have we missed something? We cant figure out what rights are missing.
Files that are created through STPs running on the stored process server should all have sassrv as an owner.
If STPs are executed not on the STP server, but on workspace server instances, then they will be owned by the user whose credentials were used to start the workspace server.
Still the best bet is to go looking in the UNIX filesystem and check ownerships and permissions on the OS level.
And if tables are registered in SAS metadata, then the authorization tab there needs to be checked also.
Log on to the UNIX server, and navigate to the file path of library Y. Do a ls -l p15_sel.sas7bdat there. You may find that the file is already there, but was created by a user other than sassrv. If that is the case, remove it or do a chown (which requires root permissions)
Hi Kurt,
it has been a while and I just had an idea. The STP that builds P15_SEL accesses a dataset that has been generated by a --different-. STP. Could it be that sassrv needs access to the source dataset that is created every morning anew?
Files that are created through STPs running on the stored process server should all have sassrv as an owner.
If STPs are executed not on the STP server, but on workspace server instances, then they will be owned by the user whose credentials were used to start the workspace server.
Still the best bet is to go looking in the UNIX filesystem and check ownerships and permissions on the OS level.
And if tables are registered in SAS metadata, then the authorization tab there needs to be checked also.
Which part of my answer put you on the right path for your solution?
There was a file on the server that had the same name and sassrv was not the owner.
Our admin had ot look twice. The files where at different locations.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: