02-09-2017 06:36 AM
I have a tricky issue. I have lots of different sas-useres which are grouped into (overlapping) user-groups. These user groups in turn have different access-rights. Now, there is one particular table that is in a library which is a connection to an oracle-database.
libname database oracle .... ;
The library has Table1 to Table5:
The problen is, that I alone should have access to Table3 but all other group-members should have access to Table1,2,4 and 5). I am assigned to the same user-group as otheres, therefore at the moment they have the same access as I do, meaning they can also open Table 3.
Is there something like a condition-property you can assign to a single table in a library, that checks who is trying to access Table3 and only grants access rights, when I try to access it?
02-09-2017 07:47 AM
If it is in Oracle, access should be determined there. Talk with your Oracle DBA people.