Desktop productivity for business analysts and programmers

Restrict access to EG during a certain time period

Reply
SAS Employee
Posts: 7

Restrict access to EG during a certain time period

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

Trusted Advisor
Posts: 2,114

Re: Restrict access to EG during a certain time period

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

Super User
Posts: 3,233

Re: Restrict access to EG during a certain time period

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.

SAS Employee
Posts: 7

Re: Restrict access to EG during a certain time period

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!

Ask a Question
Discussion stats
  • 3 replies
  • 218 views
  • 8 likes
  • 3 in conversation