BookmarkSubscribeRSS Feed
sagarmandal931
Calcite | Level 5

Hi currently we are using SAS Viya 3.4 and we need to assign dynamically roles to users according to the roles and groups getting from the LDAP and then how to integrate these users with SAS DataSets in CAS lib in Visual Analytics to give permission to reports based on there roles and group.

 

Currently, we are using row-level grant in Visual Analytics and through code as followed below: -

 

cas mysession;

proc cas;

accessControl.updSomeAcsTable /

 acs={

    {caslib="row_lvl",

     table="row_level.sas7bdat",

     identity="XYZ",

     identityType="User",

     permType="Grant",

     permission="Select",

     filter="upcase(ABC)=upcase('SUB::SAS.Userid')"}};

quit;

cas mysession terminate;

 

 

Is there a way where we could integrate LDAP roles along with row-level filters in SAS Visual Analytics.

@StuartRogers @DavidStern 

i have gone through your blogs may be you are the right person for this query

1 REPLY 1
StuartRogers
SAS Employee

Hello @sagarmandal931,

 

Did the response I wrote to your same question on the blog help?  For others the response was:

... I'd encourage you to look at the post "Examples of row-level security in SAS Viya" by my colleague David Stern. Where he walks through applying row-level security using LDAP groups. Also I would recommend reviewing the documentation for Identity-Based Substitution and the example to set a dynamic row-level filter.

 

Thank you for your time.

Stuart

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
  • 1 reply
  • 323 views
  • 0 likes
  • 2 in conversation