Restrict Access to a specific Table within a Library to certain users

[FK1]

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

[Kurt_Bremser]

If it is in Oracle, access should be determined there. Talk with your Oracle DBA people.

[ballardw]

Or place it in a separate library that only you have access to.