Row Level Filter with a table linked to many reports

[gemi]

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?

[gemi]

Anyone?

[SASKiwi]

If your query is urgent then please open a Tech Support track for your issue.

[Sajid01]

Looks like this is a duplicate of this thread
Re: Row Level filter with a table linked to many reports - SAS Support Communities