EA Security

[SNSNAN26]

I have created a package in EA 7.0 and enabled the security. EA created the admin account ID and password.

By mistake I deleted the admin account. I am now trying to open the file and it asks for user ID and password. If I give the old admin user ID and password which I deleted it gives an error that the user account is not valid.

How do I open the file: The issue is the security is enabled and their is no user account as I deleted the account.

Anybody suggest .......

[dbax]

You could try the following:
1. Open the EA project file with Access (97 or 2000) via Open With... Alternatively you can use newer version of Access (XP or 2003) and upconvert until you're done and then revert back to 97 afterwards.

2. Find the table called t_secuser and manually create the "admin" user as UserLogin=admin, FirstName=The, SurName=Administrator, Department=Administration, Password=leave it blank.
The tricky part is UserID which is required and you have to create GUID yourself (make fake table with autonumber set to GUID and add dummy record to get the GUID and then copy and paste into t_secuser). Make sure GUID is enclosed in curly brackets {}.
3. Go into table t_secgroup and copy the GroupID GUID for GroupName=Administrators. Paste that GUID into table t_secusergroup GroupID field and the copy the GUID from t_secuser that you have created in the Step #2 and copy it into UserID field of the same record. Save!

What you have done now is re-created the admin user manually by entering required data in appropriate table. You may also have to go into table t_secgrouppermission and create 33 records for the same GroupID GUID you have copied from t_secgroup in the step #3 and for each record increment the PermissionID by 1 starting from 0. I did not have to do this since it already kept that information but just in case.
I have done this long time ago in version 6.0 with success. I cannot guarantee though that you will have success too but it's worth a shot.
Let me know if it helps.

D

[SNSNAN26]

It works.... Thanks buddy