Update User name in all Ledgers

udayrmer

Hi All,

One of my client using NAV 2009 Classic client and their all users using SQL server authentication so all Ledger have SQL user id in user field.

Now they are planned to user NAV 2009 RTC, and obviously they need windows authentication, and they did it.

But they want all the past Ledger's USER ID, to be replaced by the windows USER ID.

Anyone has did it then please share the easiest way or any suggestions

Thanks in advance

bbrown

Why do they need to do this? I know they want to do it, but why?

David_Singleton

udayrmer wrote:

Hi All,

One of my client using NAV 2009 Classic client and their all users using SQL server authentication so all Ledger have SQL user id in user field.

Now they are planned to user NAV 2009 RTC, and obviously they need windows authentication, and they did it.

But they want all the past Ledger's USER ID, to be replaced by the windows USER ID.

Anyone has did it then please share the easiest way or any suggestions

Thanks in advance

Its pretty simple.

1/ Create SMITH as a Database user in Navision
2/ Synchronize users
3/ Delete SMITH
4/ GO to Database users find JS
5/ Rename JS to SMITH.

Done.

udayrmer

Thanks David,

But this will not update the user ID of the already posted Ledger. I want this to be done.

Chinmoy

You will anyways have to create all the windows users. Just replace the database user ids in the posted tables with the windows user ids with a code in a processonly report.

If you do not replace the user ids, in the posted tables (users will not be able to change these entries anyways), what is the problem?

Chn

David_Singleton

udayrmer wrote:

But this will not update the user ID of the already posted Ledger.

Did you try it :roll:

udayrmer

No Let me Try it

udayrmer

Thanks Devid,

It is working

David_Singleton

udayrmer wrote:

Thanks Devid,

It is working

It's probably best to test before telling someone they are wrong

Glad you solved your issue.