How to Determine The Order of the Directories for Crowd in the Database?

Still need help?

The Atlassian Community is here for you.

Ask the community


To determine the order of the User Directories (external user management) when Crowd admin user cannot login with the correct credentials. This is extremely useful for recovering administrator rights from the Crowd Internal Directory - Restoring Passwords To Recover Admin User Rights via Database with directories reordering.


Execute the following SQL query against the Crowd database via database client.

SELECT, m.application_id, a.application_name, m.directory_id, m.allow_all, m.list_index, d.directory_name, d.directory_type
FROM cwd_app_dir_mapping m 
JOIN cwd_directory d ON m.directory_id = 
JOIN cwd_application a ON m.application_id = 
WHERE a.application_type = 'CROWD';

(info) Recover Administrator Rights: Make sure that the list_index for Crowd Internal Directory is 0 and the remaining directories are in ascending order (1, 2, 3, ...).

2nd 1
3rd 2

Last modified on Jul 19, 2016

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.