BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
PhilipH
Quartz | Level 8

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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.

View solution in original post

7 REPLIES 7
Kurt_Bremser
Super User

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
Quartz | Level 8
Thanks! Will check that.
PhilipH
Quartz | Level 8

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
Super User

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.

PhilipH
Quartz | Level 8

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 1537 views
  • 5 likes
  • 2 in conversation