topic Re: STP and access rights, unix, wirting files in Developers

STP and access rights, unix, wirting files

PhilipH — Wed, 19 Oct 2016 08:36:21 GMT

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.

Re: STP and access rights, unix, wirting files

Kurt_Bremser — Wed, 19 Oct 2016 08:47:13 GMT

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)

Re: STP and access rights, unix, wirting files

PhilipH — Wed, 19 Oct 2016 15:44:10 GMT

Thanks! Will check that.

Re: STP and access rights, unix, wirting files

PhilipH — Fri, 18 Nov 2016 10:31:05 GMT

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?

Re: STP and access rights, unix, wirting files

Kurt_Bremser — Fri, 18 Nov 2016 12:08:54 GMT

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.

Re: STP and access rights, unix, wirting files

Kurt_Bremser — Thu, 01 Dec 2016 08:24:50 GMT

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

Re: STP and access rights, unix, wirting files

PhilipH — Thu, 01 Dec 2016 08:26:08 GMT

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.

Re: STP and access rights, unix, wirting files

Kurt_Bremser — Thu, 01 Dec 2016 08:30:06 GMT

As is often said: "Shit happens".