I have access to the JIRA server but I dont have admin access. I checked "cwd_membership" table and found that no one is having jira-administrators access. Is there a way to get admin access for me? From a different test server, I checked and found the below data from the following query.
"select * from cwd_membership where child_name='spatruni';"
But in the instance where i lost admin access i found this data
How can i get admin access? Could you please suggest?
From the documentation I checked the users who are having admin permission using the query "select child_name, directory_id from cwd_membership where parent_name='jira-administrators';" but no users returned. This is because of my accidental deletion. from the next step "If there are no Internal JIRA Administrators" I donot understand what it really means "Find the groups in the external management system that you want to grant the administrator permissions and do the following:" What does it mean finding group in external management? We are using Ldap for authentication. How the ldap group is acutally related here I do not understand. We manually assign admin permission to some specific users not based on any Ldap groups.
LDAP is providing groups and users to Jira. You need to tell Jira to treat one of the groups (one that you are in) as an administrator group. The SQL given in that "if there are no internal Jira administrators" section will do that. Once complete, you'll get access and you can repair the rest of what you deleted through the UI
I checked the below queries and found that perm_parameter value which is mentioned in the documentation is already set properly in the table. So I did not understand what should I execute here and so got confused.. Could you please let me know how to resolve this?
select * from schemepermissions where permission=44;
select * from schemepermissions where permission=0;
select * from schemepermissions where permission=1;
You are reading those permissions to find out what groups are set up with admin access (if any). Once you've established that, you can move on to the next section in the document. I cna't really give you a better explanation that what's in the documentation - it's better written than my prose, and I don't know what you aren't understanding.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG