Session Table Permissions

Jonathan2708

Hi,

I am using the Session virtual table to lookup the user's connection id to give me a unique value for populating a table. Everything works fine when logged in as Administrator but when logged in as a normal user I get 'You do not have permissions to the Session table', even though the user has the Navision 'SUPER' role.

I have got around the problem by making the SQL users DBOs, but obviously this is not an acceptable solution. Can anybody tell me what SQL permissions are required for the Session table.

Using : Navision 4.00, SQL 2000

Any help appreciated,

Jonathan

PaddyMullaney

If the object that calls the code is report you can set permissions on it. You can probably do so on other objects also. It is under the properties section

wochm

Hello!
Set Permissions property. You can use this property in every object.

Pozdrawiam/Best Regards
Marcin Woch
_____________________
"ANTEI" Woch Marcin
email: marcinwoch@wp.pl
tel.: (+48608) 39 46 29
Poland

fb

Using : Navision 4.00, SQL 2000

1) If you upgraded your db from v3.x, did you add the 'new' tables to the 'ALL' group. (See the list here. You may need to add the Session table to the list.)

2) Did you 'synchronize', then logoff/logon?

robertc wrote:

After you change any kind of security in Navision 4.0 for SQL - wheather it is new/modified/deleted any of: database logins/windows logins/roles/permissions, you must run Tools/Security/Synchronize. You must then login again. Have you done that?