BookmarkSubscribeRSS Feed
india2016
Pyrite | Level 9

Hello everyone,

 

I am stuck at tricky situation.Please free to add suggestion.

 

Scenario: We have Hadoop libname and We need to restrict only One single responsible person could access the all the table of hadoop using Libname.

 

Is there any way to restrict all other users to acess hadoop tables using LIBNAME?

3 REPLIES 3
LinusH
Tourmaline | Level 20

Sorry, but I don't really understand what you try to accomplish.

Can you give some examples, what different usera should eb able to do, and what they shouldn't be able to do.

Data never sleeps
Sajid01
Meteorite | Level 14

When accessing data from external sources using libname statement, the appropriate approach is to restrict access at the external sources leveland in this case at the Hadoop level.

 

AnandVyas
Ammonite | Level 13

If this is via a pre-assigned library in metadata then you can prevent the access using authorization layer in metadata. Ref: https://documentation.sas.com/doc/en/bicdc/9.4/bisecag/n1nesjvtxu7783n1pveml8ct4txk.htm

If it's via explicit lib-name then in order to make Hadoop connection there is a need to access the underlying JARs and XMLs which can be managed at filesystem level. You can try using explicit permissions on these files to see if it works.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 913 views
  • 0 likes
  • 4 in conversation