topic Re: Need help locking down work tables in SAS Enterprise Guide

Need help locking down work tables

deleted_user — Thu, 27 Mar 2008 17:12:43 GMT

Hi,

Does anyone know if there is a way to lock down individual work tables on the SAS server side? We are trying to limit access to critical customer information so that person A cannot log into the server and look at person B's work files. Any help you could provide would be great!

Thanks in advance!

Re: Need help locking down work tables

deleted_user — Thu, 27 Mar 2008 17:28:10 GMT

Yes it can be done.

What kind of server are you dealing with?
Each platform has its own things.

The general guideline would be that each user has their own login and workspace, which is protected by OS level security features.

SAS supports the concept of SASUSER, but you have to be careful, because SASUSER is typically a persistent library, unlike WORK. But, it is possible to have a unique WORK directory/libary for each user. For Windows and Unix, for each account, either set the SAS_User_Config environment variable, or have a sasV9.cfg file in the user's "$HOME" directory. For a mainframe, control would be through RACF.

Re: Need help locking down work tables

deleted_user — Fri, 28 Mar 2008 19:43:08 GMT

Thanks for the input Chuck! And now, I have come to find out, it was decided that we don't need to lock down our tables according to the powers-that-be. Oh well, still nice to know it can be done!