If a SD-ticket has status 'In Progress' Req. SQL Elevated user rights can be requested by selecting this option via the Workflow button.
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'
The assignee opens this ticket and enters
a reason for access in the description field.
Specifies the Admin account
Specifies the Instance, remove the non relevant options.
Specify the database name
Specifies the access required, remove the non relevant options.
Select Req. Authorizations via the Workflow button. Image Removed
This request is published on the Teamlead / Department Manager project management board for approval, status changes to Awaiting authorization.
Approver selects: 'Approved INFRA-SD' Ticket moves to status Awaiting execution Image Removed
Once approved, Status changes to Awaiting execution and Yamaha team: INFRA-SD is added. Image Added The ticket is moved to the INFRA-SD dashboard to grant the access and inform the assignee.
After access is granted Infra-SD closes the ticket. Resolution will automatically be set
The original linked ticket status is transferred back to 'In progress' after elevated user rights have been granted. .