BookmarkSubscribeRSS Feed
BhavikShah
SAS Employee

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

3 REPLIES 3
Doc_Duke
Rhodochrosite | Level 12

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

SASKiwi
PROC Star

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.

BhavikShah
SAS Employee

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!

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!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 3 replies
  • 852 views
  • 8 likes
  • 3 in conversation