STP and access rights, unix, wirting files

[PhilipH]

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.

[Kurt_Bremser]

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)

[PhilipH]

Thanks! Will check that.

[PhilipH]

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?

[Kurt_Bremser · Accepted solution]

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.

[Kurt_Bremser]

Which part of my answer put you on the right path for your solution?

[PhilipH]

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.

[Kurt_Bremser]

As is often said: "Shit happens".