Security Setup on old Model

[RTNMK]

I have an old model created in 2006 (v. 9) that has security invoked on it. I was the admin at that time but I left the company shortly after and now have returned. Noone knows any of the passwords and this model is no longer in use. I want a piece of the this model for a new one I am building but have no way of determining the password to get into it. Are there any back door abilities to look at the model and copy the portion I need? Can Sparx do it for me based on the EA keys and user identification we have? :-/

[VKN]

You can disable the security and access the model if you have the EA key.

[RTNMK]

How do you get to where you enter the EA key? If I try to open the model it asks me for the login. Do I use  the registered login?

[VKN]

I guess you can:
Cancel the login window then select Project->Security->Disable Security

[RTNMK]

That is grayed out as long as I don't have a model open.  

[VKN]

If you can't get help to crack it here, send an email to [email protected] (along with the .eap if your model is in it).

[Geert Bellekens]

Open an sql session to the .eap (= MS Access db) with your favorite SQL client and clear the password field for the Admin user in t_secuser
Then login with user admin and empty password.

Geert

[SomersetGraham]

I can confirm that what Geert suggests works
I have had a similar problem in the past and simply cleared the password field

[RTNMK]

Thanks for the feedback, but still not working for me. Using MS Access and it does not list a password attribute for t_secuser. One, I get an error that this is a really old database. I tried to update to MS Access 2010, but didn't work. Secondly, I just opened as the old type of DB and it lists the following attributes.

s_Generation, s_GUID, s_Lineage, UserID, UserLogin, Name, Blank column.

Regardless, it won't let me update anything since it is an old database.

Will try to find a DB Admin to help, but this forum has been pretty helpful so far. Thank you!

[qwerty]

Try a VB sciprt inside EA and place this inside

Code: [Select]

option explicit

!INC Local Scripts.EAConstants-VBScript

'
' Script Name:
' Author:
' Purpose:
' Date:
'
sub main
      Repository.Execute("UPDATE t_secuser SET password = ''")
end sub

mainLet it run once. Then you can login with any user int t_secuser with a blank password.

q.

[RTNMK]

how is that going to work if I can't open the model file in EA in the first place? Getting frustrated, think I may need to get Sparx to do it.

[VKN]

I tried to update to MS Access 2010, but didn't work. Secondly, I just opened as the old type of DB and it lists the following attributes.
s_Generation, s_GUID, s_Lineage, UserID, UserLogin, Name, Blank column.

You shouldn't upgrade anything later to Access 2003 format, for the purpose. Then in t_secpolicies if you can find a record where Properties='UserSecurity',  delete it.

[qwerty]

Oops  

What you might do is a transfer to a RDBMS (Tools/Data Management/Transfer) where you have a usable client to perform the SQL. Then you can transfer it back to EAP.

q.

[Dermot]

Using MS Access and it does not list a password attribute for t_secuser. One, I get an error that this is a really old database.
Regardless, it won't let me update anything since it is an old database.

The MS Access message "You can't make changes to the Database Object .." applies to changing Queries and Table structures - it does not apply to data. Just Press OK. Then  clear the entry as stated by VKN.
This works regardless of the the .eap age.

[HowardB]

The columns s_Generation, s_xxx,  indicate that your EAP file is part of a replicated database set.  For this reason, it may be prudent to avoid deleting records from the tables, but instead jsut change the values in the table.

I suggest that you update the table "t_secpolicies", with something like;

UPDATE t_secpolicies
SET Value = 'Disabled'
WHERE Property = 'UserSecurity'


You should be able to use Access 2003 or Access 2007 to perform this.
If you get error/warning messages when you try to open the EAP file, I believe you can just click OK and carry on.  The warning message may be telling you that you cannot change the structure of the table, as opposed to changing values in the table.

If all else fails, send the EAP file to Sparx and ask them to reset it for you.