BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Betty_sam
Obsidian | Level 7

Dear all,
Im working in a project, and im strugling with a task where i need to dynamically set data filter of a report.

Here is an example of my reporting table:

 

ProfessoruniversityCity
aaxxxLondon
bbyyyParis
ccxxxLondon

 

this data filter will be based on user's connection.
for example : user works in university xxx and login in to my report , he should have access only to data lines related to his university,

Im thinking using Row level security but I need to figure out how, could you plz help me?

Thank you.

Betty

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jaseit
SAS Employee

Hi Betty,

 

As an administrator, you can set row-level security based on Identity Groups. If you can group all users into custom groups corresponding to their university, you may be able to make this work. For example, if a user is at 'xxx' university, then they need to be added to a custom group named 'xxx'.

 

Under the data tab in Environment Manager, you then can right-click on the data table you wish to secure and select 'Edit Authorization.'

Then, add all of the university role groups 'xxx','yyy','zzz'. For each university, navigate to the 'Select' column and click the icon. Change the direct setting value to 'Row-level grant' where you can then put in your dynamic expression. For 'xxx' group you would put in the following expression to check whether the value of the university variable in your table corresponds to that identity group.

university in ('SUB::SAS.IdentityGroups')

 

I also recommend viewing this communities post: https://communities.sas.com/t5/SAS-Communities-Library/Examples-of-row-level-security-in-SAS-Viya/ta...

 

Hope this helps!

Jaime

View solution in original post

2 REPLIES 2
jaseit
SAS Employee

Hi Betty,

 

As an administrator, you can set row-level security based on Identity Groups. If you can group all users into custom groups corresponding to their university, you may be able to make this work. For example, if a user is at 'xxx' university, then they need to be added to a custom group named 'xxx'.

 

Under the data tab in Environment Manager, you then can right-click on the data table you wish to secure and select 'Edit Authorization.'

Then, add all of the university role groups 'xxx','yyy','zzz'. For each university, navigate to the 'Select' column and click the icon. Change the direct setting value to 'Row-level grant' where you can then put in your dynamic expression. For 'xxx' group you would put in the following expression to check whether the value of the university variable in your table corresponds to that identity group.

university in ('SUB::SAS.IdentityGroups')

 

I also recommend viewing this communities post: https://communities.sas.com/t5/SAS-Communities-Library/Examples-of-row-level-security-in-SAS-Viya/ta...

 

Hope this helps!

Jaime

Betty_sam
Obsidian | Level 7

Hi jeseit,

 

Thank you very much for your reply.

 

 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1655 views
  • 2 likes
  • 2 in conversation