Admin account corrupted

Hi to all,


in case an admin account with admin_roles has been corrupted or not available for some unexplainable reason, is there any workaround to create a new admin account with admin roles?


an idea could be to replace the row deleted in order to remove the default admin account.





PS. we are using the ijc db users

Quote:

an idea could be to replace the row deleted in order to remove the default admin account.

i forgot to add:


where is such xml file?

The user and authority information is stored the IJC_SECURITY_USERS and IJC_SECURITY_AUTHORITIES tables. If you look at the contents of those tables using SQLPlus (or equivalent) you should be able to work out what's up.





If you need to reset the security delete the appropriate row from the IJC_SECURITY_INFO table which is where the security configuration is stored. Deleting this configuration resets security back to the default settings (anonymous with admin/admin), but the users and authorities will still be present in the DB and could still be used once you re-enable DB based security.





Tim