BookmarkSubscribeRSS Feed
Ram4sas
Fluorite | Level 6

Hi All,

I am wondering how would I set up the SAS 9.4 metadata security implementation dynamically.

I have defined users (added into groups) >Groups, then Permission granted to groups on folders and Oracle library TEST(the Same user are part of Groups at OS level to ownership with W permission)

example: IT group and SALE group users are in the system.

TEST Library should be accessed by IT group users, not for SALE Group Users.

For this i have granted RM & R permissions to IT group and Deny for SALE - its working as well.

Customer expectation:

Oracle DB has role component with in it.

If user from IT group want to access TEST library that should be go to Oracle Role table to do validation  if that user has permission to access TEST library then allow to access, it not then no access to that user.

is this possible with SAS?  Would you please suggest how to implement if possible?

thank you,

Ram.

2 REPLIES 2
jakarman
Barite | Level 11

SAS Metadatasecurity in control over Oracle security who has told sold that idea?

Opening on Oracle with shared generic user is bypassing overruling Oracle.

Orcale has his own security you could connect that to LDAP and than defnining a trust. Still needing to define the user into Oracle in the same way as at the OS level.

With the indentities present in Oracle the DBA can define the roles access and logging as Oracle security is meant to be.

---->-- ja karman --<-----
Ram4sas
Fluorite | Level 6

Hi Jaap,

Thank you very much and i have convinced the same message with my customer. But i want to double check with experts.

Thank you very much.

Ram

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 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1068 views
  • 0 likes
  • 2 in conversation