Skip to Content
0
Nov 02, 2018 at 10:10 PM

Deleting a User and "Re-Adding" Before Adding License Key

97 Views

Hello:

In SAP Business One and in a test environment, I created a User ID called "AUser". Later, I realized that I should have named the ID to be "Auser".

So, I deleted "AUser", in B1.

Afterward, B1 would not let me create a new User ID called "Auser". It told me that the User ID "AUser" is still in the OUSR table. (I didn't realize that the environment is not case sensitive.)

Even though the environment has no licence key, someone told me that I cannot simply run the following script in SQL to delete "AUser" in order to afterward set up "Auser" in B1:

DELETE OUSR where USERID = 'AUser'.

He told me that, if I were to run such a script, B1 would no longer function properly.

Is he correct? I simply want to know for future reference. For now, I'm just going to play it safe and create a completely new User ID.

Thank you!

John