audit log from SQL query

[Adrian Gonzalez]

Hi people,

I need help to find some SQL query to list what user maked a roles change around a date in a project. Could anybody help me?

Thanks a lot

[Niranjan]

Hi @Adrian Gonzalez , From JIRA 8.8 the audit_log table in jira is called AO_C77861_AUDIT_ENTITY.  

If you have the date of chnage and the project name, you should be able to check it in via as project role changes are captured in UI Audit log.