User permission to Object table

franklin1232
franklin1232 Member Posts: 35
edited 2005-09-24 in NAV/Navision Classic Client
I just recreated security in my 4.0 test database. I put all my users in the "all" group which seems to have read permissions to the object table. However when I try to log on to the database I get an error saying that the user doesn't have permission to read the object table.

Any ideas why?

Comments

  • sporri
    sporri Member Posts: 7
    First of all, is your test database native C/SIDE or SQL ?
  • ngebhard
    ngebhard Member Posts: 127
    We had the same problem after migrating a customer from 3.70 native to 4.00 sql. The problem is that this table is a temporary table. Are you sure that this table is in the role "all"? As far as I remember it wasn't in there. Even as a superuser we needed to add this table to the super-role, but I think this problem was caused by sql. Are you using sql? Then try and add it again and syncronize.

    Greetz
    Nicole
    ProTAKT Projekte & Business Software AG
    Microsoft Dynamics NAV Partner
    Bad Nauheim, Germany
    http://www.protakt.de
    http://twitter.com/protakt
  • franklin1232
    franklin1232 Member Posts: 35
    We are using SQL 2000. I checked the SQL users table and all the our windows and database accounts are there. I do have some user that can get in a superuser, but others that even after I make them superusers they still can't get in.

    Object #2000000001 Object table has read permissions set for the "ALL" group, but no other permissions.
  • sporri
    sporri Member Posts: 7
    Partnersource mentions a bug in Navision 4 with permissions in the object table.
    --
    A Microsoft Business Solutions - Navision 4.0 user is assigned a database logon role that is restricted to a particular company. When the user tries to log on to the database, the user receives the following error message: You do not have permission to read the Object table.
    RESOLUTION Hotfix information A supported hotfix is now available from Microsoft
    --
    The way around it seems to be to remove the company restriction from the users or add all users to the dbo database role on the SQL server

    Sporri
  • ngebhard
    ngebhard Member Posts: 127
    There is a hotfix available that fixes the problem with roles for certain companies. Just ask the navision support! I don't think its published in partersource.

    Does this fix your problem?

    Greetz
    Nicole

    Btw: even as a superuser you need to add a role with the rights on the table "object". This is a bug as well!
    ProTAKT Projekte & Business Software AG
    Microsoft Dynamics NAV Partner
    Bad Nauheim, Germany
    http://www.protakt.de
    http://twitter.com/protakt

Categories