Deleted user by accident from SY01400

(0) Share

Report

Posted on by Community Member

Good day,

I deleted a user from the SY01400 table when what I was really supposed to do was to delete them from the activity table. I am trying to recreate the user within GP but when trying to save it gives the error than that SQL userid already exists. This is understandable but instead of creating the userid with a different name. Is there a way to retain the old userid? Meaning, is it a case where I would have to delete the existing SQL ID and then try creating over the user within GP with the same ID? I am asking as I don't know if there are any implications. So as a live example: the user is jmatt and that is what I deleted from SY01400. I try to create it back in GP but it says it already exists within SQL. Instead of creating jmatt1, can I create the jmatt over?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Richard Wheeler 75,850 Moderator on at

Like (1)

Report

You will need to go into SSMS and delete this user ID from SQL and from each company database and the DYNAMICS database.

Was this reply helpful? Yes No
JodeRuiter 982 User Group Leader on at

Like (0)

Report

I will second Richard's response - you need to open security in each db in SSMS and delete the userid from GP there. After that you can just add them back in to GP.

Was this reply helpful? Yes No
Suggested answer

Romryan on at

Like (0)

Report

What if you restore dynamics database recent backup, look for the user in table SY01400. Insert that specific record of the user in your live dynamics database specifically in the SY01400. This should be the easiest. You need to omit Dex_row_id field since its an identity field.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

You could also use SQL to remove the database logins and then create them again through the gp interface'. You don't delete the Master Login, just the database logins.

Kind regards

Leslie

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi,

Since all you did was deleting accidentally the SY01400 record from this user, yes the easiest thing would be simply to restore the last backup of your DYNAMICS DB to a different DB name (i.e. DYN_RESTORE) and copy that missing record from the SY01400 table into the live table.

After that, your user should be able to login back into GP.. That assumes that you haven't done any other action in SQL server or in GP with that user's security..

Take a backup of the DYNAMICS DB before doing anything else and try doing this off-hours when no one is in the system.. Once the user record is inserted back in SY01400, you could reset the pwd from within GP and test the user login.

Was this reply helpful? Yes No