Link between user login and application roles nav to sql

SBokhorst
SBokhorst Member Posts: 13
edited 2011-08-09 in SQL General
Hello everyone,

I am looking for a connection beween the application roles starting with $ndo$ar$.... and the user role on sql.

when a new user is created in Navision, I noticed that on database level two schema's are added the first one has the same name as the user, but the second one is created with a the name starting with $ndo$ar$

Because I have the bad feeling that there are some orphaned schemas and application roles, I like to know how to link them.

Thanks in advance.

Regards.

Comments

  • SBokhorst
    SBokhorst Member Posts: 13
    Yes I understand what you say

    I assume that now the application is also able to clean up the unused application roles.

    but it's not in the manual:) and found no button with the function "clean up unused application roles"

    Though, and I'm sorry for not sharing this before, I took the gamble, and deleted all application roles, and schema's exept the schema of my superuser. and synchronised from navision..
    Supprise; only a few application roles came back.. SQL clean and still working propper..

    Regards,

    Sjaco
  • bbrown
    bbrown Member Posts: 3,268
    Switch to Standard Security model and you won't have to deal with this.
    There are no bugs - only undocumented features.

Categories