It does matter what kind of OS you are using and how comfortable you are organizing security at that level. OS categories: - With the common used Windows using the Active directory, you have very advanced options that are well known and fit into common management The most easiest approach is defining data accordingly in those kind of locations. - Mainframes are well managed, just find the RACF people and you can solve it. - Unix/Linux is the exception as often very bad managed and blaming all other tools for complexity. This is not needed as also in Unix/Linux security can easily managed when all technical prereq are known. - An external DBMS often has very advanced authentication and security. When the libname to an external RDBM is able to set up with different setting according to you requirements you can solve this at that level. All this is needing cooperation with those guys. They have the tools to do it. If all data is in one table and several persons may see just some part you are having an issue. This is a common issue with OLAP there row-level access has been introduced. It is requiring only mediated access by predefined programs executed. There is not anything within SAS solving your question to views to isolating those partial datasets. If SAS with some coding is an option for your users, they always can find a way to access all data. It is becoming like a kids hiding game (obscure = hiding).
... View more
