Jira Project Role Related Table

AMARJIT GHOSH

If I create a new project role and able to see in the 'Comprehensive Audit Log' in which database table we can get the data ? Please mention the table name and also mention logfile which is generated in the server. 

Renata_Getint

When you create a new project role in Jira, the following resources will help you identify the database table and log file that store the related information:

1. Database Table

Project role information is typically stored in the projectrole and projectroleactor tables in the Jira database. Here's a quick breakdown:

• projectrole: Contains details about the roles, such as role ID, name, and description.
• projectroleactor: Maps roles to users or groups within specific projects.

Make sure you have appropriate access to query the database, as this requires administrative permissions. Always test your queries in a non-production environment to ensure data integrity.

2. Log Files

Changes to project roles, including creation, modification, and deletion, are logged in Jira’s application logs:

• Log File: atlassian-jira.log
• Location: Found in the <JIRA_HOME>/log/ directory on the server.

You can use the Comprehensive Audit Log in the Jira UI to verify the change and cross-reference it with entries in the atlassian-jira.log. Look for events tagged with ProjectRoleManager or specific entries mentioning the role name or project.