DATA Step, Macro, Functions and more

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

Reply
Occasional Contributor FK1
Occasional Contributor
Posts: 19

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

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

 

 

 

Super User
Posts: 7,831

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

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 11,343

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

Posted in reply to KurtBremser

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

Ask a Question
Discussion stats
  • 2 replies
  • 117 views
  • 0 likes
  • 3 in conversation