After restoring login to Bamboo, admin no longer sees full list of admin options.

alex fan

Hi, 

I followed the instructions below to recover Bamboo login.

https://confluence.atlassian.com/bamkb/bamboo-lost-connection-to-the-external-user-directory-preventing-users-from-logging-in-678691207.html

However, when I logged in to Bamboo and I clicked on the cog icon on the top right hand corner of the page, all I see is Linked Repositories under Bamboo Administration. Normally, I can see Overview, Agents, Global Variables, Linked repositories, User Management and Add-ons. 

Has anyone come across this issue before?

Regards, 

Alex

Gabriel Ribeiro

Hi Alex,

It looks like the local user doesn't have "Admin" rights. Are you sure that this user is a member of the bamboo-admin group? Also, if you're using LDAP could you please check if this user is also available in the LDAP server? If yes please remove the LDAP parameters from the atlassian-user.xml file, restart Bamboo and try again.

To check the permissions from the database, please run the below query:

<span>SELECT</span> AE<span>.</span>SID <span>AS</span> NAME<span>,</span>
        <span>(</span><span>CASE</span>
          <span>WHEN</span> AE<span>.</span><span>TYPE</span> <span>=</span> <span>'PRINCIPAL'</span>
               <span>THEN</span> <span>'USER'</span>
          <span>WHEN</span> AE<span>.</span><span>TYPE</span> <span>=</span> <span>'GROUP_PRINCIPAL'</span>
               <span>THEN</span> <span>'GROUP'</span>
        <span>END</span><span>)</span> <span>as</span> USER_OR_GROUP<span>,</span>
       <span>(</span><span>CASE</span>
          <span>WHEN</span> MASK <span>=</span> <span>1</span>
               <span>THEN</span> <span>'ACCESS'</span>
          <span>WHEN</span> MASK <span>=</span> <span>4</span>
               <span>THEN</span> <span>'CREATE PLAN'</span>
          <span>WHEN</span> MASK <span>=</span> <span>1024</span>
               <span>THEN</span> <span>'CREATE REPOSITORY'</span>
          <span>WHEN</span> MASK <span>=</span> <span>16</span>
               <span>THEN</span> <span>'ADMIN'</span>
        <span>END</span><span>)</span> <span>as</span> PERMISSION_TYPE
  <span>FROM</span> ACL_ENTRY <span>AS</span> AE
  <span>JOIN</span> ACL_OBJECT_IDENTITY <span>AS</span> AOI
        <span>ON</span> AE<span>.</span>ACL_OBJECT_IDENTITY <span>=</span> AOI<span>.</span>ID
<span>WHERE</span> AE<span>.</span><span>TYPE</span> <span>IN</span> <span>(</span><span>'PRINCIPAL'</span><span>,</span><span>'GROUP_PRINCIPAL'</span><span>)</span>
   <span>AND</span> AE<span>.</span>GRANTING <span>=</span> <span>true</span>
   <span>AND</span> ACL_OBJECT_IDENTITY<span>=</span><span>'65537'</span>
 <span>ORDER</span> <span>BY</span> NAME<span>,</span> PERMISSION_TYPE<span>;</span>

From: How to retrieve user and group access mappings / permissions from the Bamboo database

thanks