Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 263 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
A security filter has been applied to table General Ledger S
engsiong75
Member Posts: 143
Hi
I am working on a NAV 2013 R2. I was setting up the security when users started complaining that they could not login. I found that when they login, there was this error message. “A security filter has been applied to table General Ledger Setup. You cannot access records that are outside of this filter.”
I assumed that the error implied that a user had a security filter on the Table General Ledger Setup. It turned out that that was not the case. It was because there was a Permission for the TableData for ObjectID 0. There was Indirect for the Read Permission, Insert Permission and Modify Permission. Once I have deleted this permission, the program worked as normal.
Naturally, I think that the product needs a more accurate permission error.
I am working on a NAV 2013 R2. I was setting up the security when users started complaining that they could not login. I found that when they login, there was this error message. “A security filter has been applied to table General Ledger Setup. You cannot access records that are outside of this filter.”
I assumed that the error implied that a user had a security filter on the Table General Ledger Setup. It turned out that that was not the case. It was because there was a Permission for the TableData for ObjectID 0. There was Indirect for the Read Permission, Insert Permission and Modify Permission. Once I have deleted this permission, the program worked as normal.
Naturally, I think that the product needs a more accurate permission error.
0
Comments
This issue has an interesting side effects. One day when I was at the customer's office, the users suddenly encountered this issue. I checked with the administrator and I found out that she was in the middle of adding a new permission in the Permission Set BASIC but she had not found the correct table. The Object ID was zero and the permission to Read, Modify, Insert and Delete was all blank.
The administrator was in the middle of setting up a permission caused all the users immediately to have login issue. Now when she is creating new permission in the Permission Set, she changes the Object ID from 0 to 3 first before looking for the table.
And of course, you can login to the database if you only have an account. But you can't open any Company since some initial settings are necessary, that's nothing uncommon from my point of view.