PawelWiki

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;