Cannot Access Session

yukon

Hi All,

I created one Role at my nav database. Then that role can be access to 'Session' table(All properties) and set only one company. When i check session status at database info form. I got 'You don't have to permission read the session table' error. When i remove company above role. I can check session status.

Why can't access session table when i set one company? Kindly please let explain.

Best Regards
Yukon

Sog

because session is not companyspecific, it contains data common to all companies (even common to all databases but that is irrelevant in this case).

yukon

Hi Sog,

Thank for your quick reply. I know what should i do.

Best Regards,
Yukon

Sog

Case  "I know what should i do"
  "I know what I should do":
     Glad to help, good that you know what to do.
  "I know. What should I do?"
     See below

Make the role not companyspecific?
Users with access to session will see all the sessions, you cannot filter on company, nor can you edit the session table, because it is from the master db.
You have 2 options here, either the user can see all the session, or the user can see none at all.

yukon

Hi Sog,

I removed company spec: from my role. . In my case i need to read session table.

Best Regards,
Yukon