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

FK1 — Thu, 09 Feb 2017 11:36:50 GMT

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,

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

Kurt_Bremser — Thu, 09 Feb 2017 12:47:48 GMT

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

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

ballardw — Thu, 09 Feb 2017 16:16:08 GMT

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

topic Re: Restrict Access to a specific Table within a Library to certain users in SAS Programming

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

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

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