Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: K N on February 22, 2013, 03:12:48 am

Title: User security in EA repository
Post by: K N on February 22, 2013, 03:12:48 am

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

Title: Re: User security in EA repository
Post by: qwerty on February 22, 2013, 03:23:11 am

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.

Title: Re: User security in EA repository
Post by: K N on February 22, 2013, 03:34:43 am

thanks a lot qwerty!!!

Title: Re: User security in EA repository
Post by: Geert Bellekens on February 22, 2013, 06:21:15 pm

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