New SQL user on my Dynamics NAV database

nathaliet
nathaliet Member Posts: 9
edited 2013-10-29 in NAV/Navision Classic Client
Hi,
I would like to create a new SQL user (with read-only privileges) on my Dynamics NAV database for datawarehouse connection.
This user doesn't exist in Dynamics NAV and I would prefer not to create it.
Everything works weel except whel I create / update a SQL user from NAV (Tools / Security / Database logins), then my "SQL only" user is deleted.

Does someone has already faced such a problem ? What is the right way to proceed ?

Thanks for your answers.

Nathalie

Comments

  • bbrown
    bbrown Member Posts: 3,268
    Add the user into NAV, but don't assign it any roles. This will prevent it from getting deleted when a security sync is done in NAV. But, since it has no roles, it will have no access from within NAV.
    There are no bugs - only undocumented features.
  • nathaliet
    nathaliet Member Posts: 9
    Thanks, I will create this user in Navision without roles.
    Nathalie

Categories