User security in EA repository

[K N]

Hello

I am having issues in accessing the EA repository after applying user security.

I accidently deleted the Admin user from the Manage Users option in Security. I am in a deadlock situation that i cannot do anything with the repository - cant even replace this one.

Also, want to know when the user security is enabled in the repository, what tables in the schema are updated and by what values? Hopefully this helps me in getting out of this deadlock

DBMS for the repository - MySQL.
MySQL script for creating schema - MySQL_MyISAM_EASchema.sql

Thanks
KN

[qwerty]

Try

Code: [Select]

DELETE FROM t_secpolicies WHERE Property = "UserSecurity"That will turn off security. You can then turn it on again using the key.

q.

[K N]

thanks a lot qwerty!!!

[Geert Bellekens]

Another option is to grant another user all rights.
All you need to do is get the userID of a user (t_secuser)
and then execute

Code: [Select]

insert into t_secuserpermission (UserID,PermissionID) values ('{26DB68A1-75BB-4f7d-993E-623911D02B93}',0)
insert into t_secuserpermission (UserID,PermissionID) values ('{26DB68A1-75BB-4f7d-993E-623911D02B93}',1)
<snip> ... all other permission id's...</snip>
insert into t_secuserpermission (UserID,PermissionID) values ('{26DB68A1-75BB-4f7d-993E-623911D02B93}',33)
insert into t_secuserpermission (UserID,PermissionID) values ('{26DB68A1-75BB-4f7d-993E-623911D02B93}',34)replacing {26DB68A1-75BB-4f7d-993E-623911D02B93} by the actual user id from t_secuser

Geert