Hi, I have this situation:
User1 has the authorization to view just 2 reports, named REPORT_A and REPORT_B. Of course, the authorizations are not assigned directly to the user but to the groups to which he belongs (GROUP_REPORT_A and GROUP_REPORT_B).
Both reports are built with few tables and they have a table in common, named TABLE_X.
This TABLE_X has a lot of data, columns, rows.. but has a column identifying city names, named NAMENATION.
For example, this column has values like "Paris", "Milan", "New York"...
I would set authorizations so that when User1 opens REPORT_A , he will see the report without any filters. But when he opens REPORT_B, he will see the report filtered by NAMENATION.
I have setted authorizations on TABLE_X in this way:
GROUP_REPORT_A: ReadInfo --> Grant ; Select --> Grant
GROUP_REPORT_B: ReadInfo --> Grant ; Select --> Row-Level Grant (NAMENATION = 'Paris').
Unfortunately in this way, User1 always sees, for both records, all the data without filters.. where am I wrong?
If your query is urgent then please open a Tech Support track for your issue.
Looks like this is a duplicate of this thread
Re: Row Level filter with a table linked to many reports - SAS Support Communities
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.