Hi,
does somebody know, how I can limit the access rights to certain tables (and certain records in the table)
for a user of Jet Reports.
In Navision 2009 (or other versions) I can assign roles to employees and based on the role they can only see what I
want them to see.
I can set a security filter to further reduce the rights of NAV-Users.
However, if I connect with Jet Reports to the Database (with the Login of a restricted role),
I can see all tables and all records.
Ignores JetReports the access rights of Navision (the help-function of JetReports
implies, that JetReports doesn't ignore them) or am I doing something wrong.
Thanks in advance.
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Goblin187,
I'm not sure what you are seeing, however, I can tell you that Jet Reports doesn't do anything with security. This is 100% a function of C/Front provided by Microsoft. There have been some issues with the use of Security Filters in NAV in past versions of C/Front, however, in my testing, we have the same limitations in NAV 2009 with Security Filters that we had in NAV 5.01.- C/Front always allows us to see all tables because we use the Object table to get the list of tables.
- C/Front controls access to tables based on the permissions set in NAV.
- C/Front doesn't properly handle NAV Security Filters. Older versions of C/Front ignored Security Filters, newer version give us an error if we attempt to access data restricted by the Security Filters (this is not the expected behavior)
Here is a link about NAV Security Filters (in brief)
http://www.navision-girl.com/2007/02/security-filter-record-level-security.html
A quick google search of NAV Security Filters http://www.google.com/search?q=navision+security+filters&hl=en show some of the problems and unanswered questions about working with Security Filters. -
Jet Reports Historic Posts Thank you for your answer.
Would have thanked ealier, but I was on holiday.
Please sign in to leave a comment.