Link between user login and application roles nav to sql

SBokhorst

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.

SBokhorst

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

Switch to Standard Security model and you won't have to deal with this.