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 sys.tables
select * from sys.columns
SELECT t.name AS table_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID order by table_name
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;