topic Restrict access to EG during a certain time period in SAS Enterprise Guide

Restrict access to EG during a certain time period

BhavikShah — Fri, 15 Feb 2013 17:29:13 GMT

Hi,

We are trying to implement a solution where we would like to restrict the user accessing the sas tables during a certain time period(due to lock out issue) when our processes are running and loading those tables.

What would be the best way to implement this?

Thanks

Re: Restrict access to EG during a certain time period

Doc_Duke — Fri, 15 Feb 2013 19:18:18 GMT

Tough problem. One way might be to have the process that loads the tables change the permissions on the files or directories to only allow that process access and then change it back at the end.

If the user has the file(s) open before the time window starts, I don't know of anything to do except to use the OS to kill the SAS and EG processes.

Doc Muhlbaier

Duke

Re: Restrict access to EG during a certain time period

SASKiwi — Sun, 17 Feb 2013 19:16:39 GMT

One option that would be worth considering is to have one workspace server for production jobs and another for EG users. In SAS Management Console you can stop the Workspace Server for EG users while your production Workspace Server continues running.

Stopping the server will stop EG users either connecting to or running any jobs on your SAS server so it is very much a sledgehammer solution.... You can also stop a workspace server via a program if you want to do it automatically.

Re: Restrict access to EG during a certain time period

BhavikShah — Mon, 18 Feb 2013 15:47:32 GMT

Thanks @Doc and @SASKiwi.

We do plan to kill all the SAS and EG processes before starting the batch jobs.

Will look at both the options provided and implement the feasible option.

Thanks again!