the exceute permission was denied on the object 'xp_ndo_enumusersids'


I added a new windows user in dynamics NAV 2009 R2 user Classic client, I assigned him role ; SUPER (all permissions) and I did : synchronize all logins.

I checked in SQL server every things seems ok.

But when I launch RTC client for this user, I have an error message :

{microsoft]{odbc sql server driver} {Sql server} the exceute permission was denied on the object 'xp_ndo_enumusersids, database ‘master’,

Did you have any idea to correct it ?

Thank you for your help

you can try this

raf, Mohana already answered you, I can add the following:

If “old” users can access NAV and the problem arose only when you added a new user, likely you have a very jealous DBA, who has removed PUBLIC execute rights on those 2 extended stored procedures and instead assigned them individually to each SQL login, that really needs them (read, all NAV users).

Maybe you should follow that pattern and instead of assigning PUBLIC, as is described in the link Mohana gave you, assign the rights to the new user personally, if your company’s policy is so strict.