topic Re: ownership of /saswork table if alunched by shared account in Administration and Deployment

ownership of /saswork table if alunched by shared account

singhaisurbhi02 — Mon, 01 Jan 2024 06:37:04 GMT

HI there, I have one question, like if program ran by shared identities (eg.sassrv) and there is table in /saswork location which is huge ,I want to know the ownership of the file. How can get this detail in case of sas 94.

Thanks,

Re: ownership of /saswork table if alunched by shared account

Patrick — Mon, 01 Jan 2024 07:30:33 GMT

SAS WORK and all its content is session specific and owned by the user that created the session.

Re: ownership of /saswork table if alunched by shared account

singhaisurbhi02 — Mon, 01 Jan 2024 09:03:58 GMT

Thanks Patrick,
What would be the case in term of pooled workspace server , as it uses shared identity. like someone is created big table how would I be able to identify the user in that case, if it other location than SASwork.

Re: ownership of /saswork table if alunched by shared account

Kurt_Bremser — Mon, 01 Jan 2024 15:33:09 GMT

To the operating system, the owner of such a file will be the same as the owner of the process which creates the file. Which means that all files created by a Pooled Workspace Server will belong to sassrv.

If you need to know which of your users creates large files in WORK, then simply do not let them use a pooled server from Enterprise Guide or SAS Studio.

Re: ownership of /saswork table if alunched by shared account

singhaisurbhi02 — Thu, 04 Jan 2024 10:11:19 GMT

Thanks