Hi
I have Navision 2016
We use Windows Authentication and the userids in NAV are linked to Active Directory.
There is a former user whose AD id was SMITHS this user no longer works at the company and has been disabled in AD
However, there is a new user with the same user id now. Domain\SMITHS
Is there an easy way for me to update the existing SMITHS in NAV to associate it with the current SMITHS and not the previous person ?
Thanks
0
Answers
update [NAVISION2016].[dbo].[User] set [Windows Security ID]='S-1-5-21-xxxxxxxxxx-xxxxxxxxx-xxxxxxxxx-xxx' where [User Name]='DOMAIN\SMITHS'
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
wmic useraccount get name,sid
With this command you can find the Windows Security ID by using CMD Prompt.
After finding it you can just use the query described above by KTA8.
Thomas Barbut
Having said that - why would you ever want to reuse the account id in the first place?
Every transaction data/register record/posted invoices/shipments/receipts, audit trail records stores the User ID of the user who created that entry. All of those are linked to the previous user and by 'reusing' the account you will effectively re-assign all those entries to this new user.
Also - does the 'new SMITHS' works in exactly the same place and is supposed to have exactly the same permissions as the old one?
I'd be rather insisting to NOT to have another AD account created having the same ID as some old removed account, and if IT already had created one I'd be asking them to rename the account and keep account name uniques.
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03