Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Using security filter permission in Reporting Services
bidgeir
Member Posts: 2
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
My question is therefore. Is it possible to see in the database what restriction the security filter is applying?
Regards,
Ásgeir Gunnarsson
0