Deleted admin user - very embarrassing :-|

[Barry_Pearce]

 

Oh dear...oh dear. I enabled security, deleted all the users and then closed the model. I know I know silly but it happened..long story how....

ARGH.

I can no longer get back into my model!!! HELP!!! How do I recover from this situation!?

Regards,
Barry

[Bruno.Cossi]

I haven't tried this but I think it will work:
1. Create new empty project file
2. Go to menu Tools > Data Management > Data Transfer and perfrom data transfer from your original project to the new one
3. After the transfer, you are still connected to the new project. Go to Project > Security and create new users.

Let me know if this helps. I know another way, but it is a bit of workaround, this sounds more simple.

Bruno

[Barry_Pearce]

Hehehe.

Right we'll start with the good news - its back

But your method if used as presented doesnt work - it copies the  security settings as well - including the lack of admin user. so EAP -> EAP doesnt work.

However, as we were migrating to a MySQL database anyway you set my little grey cells moving and what you do is...Move EAP to DBMS -  then in the dbms tools (i used mysqlcc) add the missing admin record back to the databse in table t_secuser password is plain text.

Cheers very much for the help!

- I have reported a fault however - as to be honest if you delete all users with user admin rights then the model becomes a dead duck as such and I think security should have been automatically disabled (or alternatively you should not be able to delete the last privileged administration user...



Were happy anyway

[Bruno.Cossi]

Good :-)

[Barry_Pearce]

Not the full story - to complete the picture....

Create a new model in the mySQL database,

copy the tsec_* tables which have data on the new model but not on the old. This gives you a VALID admin login - security can then be switched off if required - are admin'd properly now.