Session Table Permissions

Jonathan2708
Jonathan2708 Member Posts: 552
edited 2005-04-13 in NAV/Navision Classic Client
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

Comments

  • PaddyMullaney
    PaddyMullaney Member Posts: 59
    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
    wochm Member Posts: 26
    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
    fb Member Posts: 246
    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?

Categories