This is an old revision of the document!
Below is the list of SQL queries to perform tasks directly on the database. Please note that you should always shut down Jira & backup your database before performing any of these queries.
select * from cwd_user where lower_user_name = 'abc'
SELECT * from cwd_group
select * from cwd_directory
select * from cwd_user where directory_id = 1 and (user_name != 'abc' and user_name != 'cde' and user_name != 'sysadmin');
select id, directory_name, active from cwd_directory;
Then you want to use this information to disable the directory
update cwd_directory set active=0 where id=123456;