topic Re: How To Constrain/Limit Usage in Administration and Deployment

How To Constrain/Limit Usage

BruceAlexander — Fri, 16 Oct 2015 17:05:12 GMT

Folks,

Am new to SAS and planning a new installation.

I am hoping someone has already solved the questions I am posting and can share your learnings/experiences.

Am wanting to constrain/limit usage in our sandbox environment.

How can I...

1) Constrain the amount of disk storage consumed by an individual user?

2) Limit the amount of processing resources (i.e. cpu, memory, i/o) allocated to any particualr active session?

3) Limit/prevent access to recurring schedules?

4) Limit/prevent ability to write back to a DBMS?

Thanks In Advance,

Bruce

Re: How To Constrain/Limit Usage

LinusH — Sat, 17 Oct 2015 06:56:53 GMT

1) Yes, but not using SAS tools. You need to explore the options in your OS.
2) See 1).
3) Please elaborate about this one.
4) Yes. But how to design this is a not a binary matter. You can limit authorization in the RDBMS and in SAS metadata as well. So you need to document the requirements for the environment first and then design the authorization pattern.

Re: How To Constrain/Limit Usage

Kurt_Bremser — Mon, 19 Oct 2015 06:18:33 GMT

1 and 2 are clearly tasks for the operating system administration. 1 is done with defining quotas for users/groups, 2 by using a tool like the AIX workload manager.

3 needs further clarification. Define "schedules".

4 is a task for the DBMS administrator. Once permissions are correctly set within the DBMS, users will not be able to exceed them from within SAS. Do NOT use a shared DBMS ID; instead have every user use his/her own ID when connecting to the DBMS.

Re: How To Constrain/Limit Usage

BruceAlexander — Mon, 19 Oct 2015 15:17:08 GMT

Thanks for the responses. Had anticipated that I would be looking outside SAS to address these, but thought I would run the questions by experienced admins.