Can you restore a deleted user?

[Former Member]

Is there a supported way to restore a 'deleted' user?

Client has accidentally deleted a user. The database record is not actually deleted, but OUSR.Groups is set to 99, so the record is still there.

The clicnt does not want to replace the deleted user with another because they have several databases so they would have to do it in them all to avoid using another licence.

I suspect that there is not a supported way to do this, but I thought that I would check on here.

Regards,

Douglas

[former_member187989 · Accepted solution]

hi doughlas,

Check this sap

note 827232 - Recreation of deleted users

Summary

Symptom

It is not possible to recreate a user that has been removed with the
same user code. When trying to do so, error message "Cannot insert
duplicate key" is displayed.


Other terms

Cancel, remove, delete, add, code, name, SAP Business One


Reason and Prerequisites

It is by design that a user that has been removed is still stored
in user table OUSR as he might be linked to transactions and
therefore needs to remain in the table. The field "User Group" in
table OUSR indicates whether a user is deleted or not (deleted users
have the value "99" in this field).


Solution

You need to recreate the user with a different code.


Header Data

  
Release Status: Released for Customer 
Released on: 16.03.2005  08:37:17 
Master Language: English 
Priority: Recommendations/additional info 
Category: FAQ 
Primary Component: SBO-ADM-SET-GEN General 

Affected Releases

Release-Independent

hope it will solve problem.

Jeyakanthan

[jitin_chawla]

Hi,

It would not be possible to restore a deleted user.

You have to create a new one with similar code to the deleted user with some changes.

The Note referred to you by Jeyakanthan is relevant in your case.

Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Thanks for replies. You've confirmed what I thought - that it is not possible.

[Former Member]

Hi Douglas,

Create a New user code Instead of deleted user. Not Possible to restore a deleted User.

*Close the thread if issue solved.

Regards

Jambulingam.P

[Former Member]

You may log a support ticket to try if support team could restore the user for you.

Thanks,

Gordon