Skip to Content
author's profile photo Former Member
Former Member

Can you restore a deleted user?

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Jul 17, 2009 at 10:21 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2009 at 06:55 PM

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

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 17, 2009 at 07:27 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2009 at 09:28 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2009 at 06:38 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.