no permision to read database table (2000000048) in 4.0

BGI
BGI Member Posts: 176
edited 2005-07-18 in NAV/Navision Classic Client
When we startup we do some reads in table datababas (2000000048).
We have sql 2000 + navision 3.70 and windows login. Users only have public role on sql.

When we port the installation to 4.0, we are getting this error when a user with only the public role tries to read this table.
When we give the user dbowner role, everything is OK, but i don't want every user to be dbowner.....

Anyone experienced the same thing, and found a way around it or the correct security setting?

The user in navision itself has a SUPER role (for the moment)...

Rgds
Benny
Rgds
Benny Giebens

Comments

  • Arhontis
    Arhontis Member Posts: 667
    Hi,

    have you tried to place the read permission for the table 2000000048 in the codeunit/table you do the reads on the database table?
    Regards,
    Arhontis

    https://forum.mibuso.com/search
  • BGI
    BGI Member Posts: 176
    Yep tried that, no result.

    But to folow up, we got an answer from Microsoft.


    If you add new permissions in 4.0 sql, you need to syncronize. At that stage roles are created on the sql site, creating all the necessary tables specified.......except virtual tables.

    So if you have a role with tabledata 0 in it, it does not give you all the privileges to all tables. Some tables you need to specify in addition to tabledata 0, such as the table with databases, sessions and some others...

    Microsoft specified that this is NOT a bug, but a feature..which isn't described in any document....

    But we have now a workaround...

    Thnx
    Benny Giebens
    Rgds
    Benny Giebens

Categories