Page History

Elevate user rights request is used for SQL cluster access.
Access is granted for 1 day and will be removed by the end of the day via a automated script.

Explanation of access required can be found on the following page: Active Directory groups for SQL cluster

Step-by-step guide

1. If a SD-ticket has status 'In Progress'   Req. SQL Elevated user rights can be requested  by selecting this option via the Workflow button.
   Image RemovedImage Added
2.  A new authorization request ticket is created (linked as 'implements' to the original user ticket).
   Status of the original ticket changes to 'Pending Linked ticket execution'
   Image RemovedImage Added
   
3. The assignee opens this ticket the newly created linked authorization request and enters in the description field
   
   1. a reason for access in the description field.
   2. Specifies the Admin account
   3. Specifies the Instance, remove the non relevant options.
   4. Specify the database name
   5. Specifies the access required, remove the non relevant options.
      
      
      
      
4. Select Req. Authorizations via the Workflow button.
   Image RemovedImage Added
   
   
5. This request is published on the Teamlead / Department Manager project management board for approval, status changes to Awaiting authorization.
   
   
   
6. Approver selects: 'Approved INFRA-SDENGINE'
   Image RemovedImage Added
   
   
7. Once approved, Status changes to Awaiting execution and Yamaha team: INFRA-SD ENGINE is added. 
   Image RemovedImage Added
   The ticket is moved to the INFRA-SD  ENGINE dashboard or Board to grant the access and inform the assignee. 
   Image RemovedImage Added 
   
   
8. After access is granted Infra-SD team ENGINE closes the ticket.
   Image RemovedImage Added
   Resolution will automatically be set
   Image RemovedImage Added
   
   
9. The original linked ticket status is transferred back to 'In progress' after elevated user rights have been granted.
   Image RemovedImage Added.

Related articles

...