Permissions on session-table

HenningTh
Member Posts: 59
Hi all,
Hope someone knows the solution to the following problem:
Have a program reading the session-table 2000000009, filter "My session" = TRUE. I the use the ID in a temp.table (to seperate users data).
As superuser everything works properly. Have made a role and attached to user with more limited permission. He gets the: "You do not have permission to read from.................
This role grants (Native database - 2009 SP1):
Object Type Object ID Object Name Read Permission Insert Permission Modify Permission Delete Permission Execute Permission Security Filter
Table 2000000009 Session Yes
Says YES in reading permission on Session table.
Thanks in advance
Hope someone knows the solution to the following problem:
Have a program reading the session-table 2000000009, filter "My session" = TRUE. I the use the ID in a temp.table (to seperate users data).
As superuser everything works properly. Have made a role and attached to user with more limited permission. He gets the: "You do not have permission to read from.................
This role grants (Native database - 2009 SP1):
Object Type Object ID Object Name Read Permission Insert Permission Modify Permission Delete Permission Execute Permission Security Filter
Table 2000000009 Session Yes
Says YES in reading permission on Session table.
Thanks in advance
0
Comments
-
Hi
I dont remember the whole story at the moment, but if I remember correctly, we had a similar problem, especially when some users had roles limited to a given company, due the fact that session is shared along all companies in the db. Do overcome this problem we used a work around, using another unique value to separate between user sessions.
Hope this helps
Thomas0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions