Permissions on session-table

HenningTh

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

ta5

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
Thomas