Hello Experts,
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:
database.Table1
database.Table2
database.Table3
database.Table4
database.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?
Best regards,
FK
If it is in Oracle, access should be determined there. Talk with your Oracle DBA people.
Or place it in a separate library that only you have access to.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.