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.

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.
   
2.  A new authorization request ticket is created (linked as 'implements' to the original user ticket).
   
   
3. The assignee opens this ticket and enters
   
   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.
   
   
   
   
   
5. This request is published on the Teamlead / Department Manager project management board for approval, status changes to Awaiting authorization.
   
   
   
6. Approver selects:
   Image Added
7. Ticket moves to status Awaiting execution
   Image Added
8. Once approved, Status changes to Awaiting execution and Yamaha team: INFRA-SD is added.  The ticket is moved to the INFRA-SD  dashboard to grant the access and inform the assignee. 
   Image Added  Image Removed
   
   
9. After access is granted Infra-SD closes the ticket.
   That concludes the process, the ticket is closed, Access is granted for 1 day and will be removed by the end of the day via a automated script
   Image Added
   Resolution will automatically be set
   Image Added
   
   
10. The original linked ticket status is transferred back to In progress after elevated user rights have been granted.
    Image Added.

Related articles

...