Confluence Docs 3.0 : How to Restore Deactivated Users This page last changed on Mar 02, 2009 by jlargman. ### Symptoms A user that has been deactivated in the past cannot be brought back to life. Even if assigned to the right groups with confluence access.
| Note that this applies only to the older mechanism for user deactivation. In newer versions of Confluence, users are removed by removing them from groups with can-use permission, as described in Removing a User.
4. ### Cause In older versions of Confluence users have been deactivated by inserting a row into table os_propertyentry with entity_id = theUserId AND entity_key=confluence.user.deactivated This entry is still evaluated but there is no mechanism in newer version to remove this from the DB. ### Resolution Backup Confluence Stop Confluence Find the user id (=theUserId) of the particular user in table users Run the following SQL query to identify the row that contains the 'deactivated' information. The entity_name column should have an entry like 'LOC_username':
       select *  from OS_PROPERTYENTRY WHERE entity_id = theUserId AND entity_key="confluence.user.deactivated";
Delete this row from the table Restart Confluence. ### Additional Information
Severity | Medium
Regular Expression | (remove|restore).*deactivated user
Article ID | CONFKB152044814
Searching Confluence Knowledge Base

Document generated by Confluence on Nov 05, 2009 23:34