10-16-2015 01:05 PM
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,
10-17-2015 02:56 AM
10-19-2015 02:18 AM
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.