Using security filter permission in Reporting Services

bidgeir

Hi. I am not an Nav user nor Nav developer, but a MS BI developer. I don't know Nav very well. One of our clients has Nav and wants to be able to use permission set in Nav for SSRS reports. They use windows logins. The way I want to implement this is by grabbing the username of the user running the report and see if the have the right to read the data. This is no problem with conventional roles, as I can always read from the Nav tables what tables the user (or group) can read, but the problem is security filters. The client har applied security filters on several roles but when I look in the permission table the security filter is only represented by a hash code.

My question is therefore. Is it possible to see in the database what restriction the security filter is applying?

Regards,

Ásgeir Gunnarsson