AWS RDS Access Workflow Automation
Budget: ₹1,100 – ₹4,100 INR
Database Access Request Workflow Description
If a user requires access to database(AWS RDS) of an application, they must initiate the request through one of the designated platforms: either a Google Form or ServiceNow.
Once the request is submitted via either platform, it is automatically routed to one of the designated approvers (e.g., ABC or XYZ) for first-level approval. The approvers receive an email containing a secure "Approve" link.
When an approver clicks the "Approve" link, it triggers an AWS Lambda function, which performs the following actions:
Generates a random database username along with a secure, auto-generated password
Sends an email to the requester with the generated database credentials
Grants access to the application database for a limited duration of four hours
After the four-hour access window, the system automatically revokes the access and deletes the temporary credentials.
Finally, a notification email is sent to the user & approver confirming the revocation of their database access.
Note:- It should be done by python programming
If a user requires access to database(AWS RDS) of an application, they must initiate the request through one of the designated platforms: either a Google Form or ServiceNow.
Once the request is submitted via either platform, it is automatically routed to one of the designated approvers (e.g., ABC or XYZ) for first-level approval. The approvers receive an email containing a secure "Approve" link.
When an approver clicks the "Approve" link, it triggers an AWS Lambda function, which performs the following actions:
Generates a random database username along with a secure, auto-generated password
Sends an email to the requester with the generated database credentials
Grants access to the application database for a limited duration of four hours
After the four-hour access window, the system automatically revokes the access and deletes the temporary credentials.
Finally, a notification email is sent to the user & approver confirming the revocation of their database access.
Note:- It should be done by python programming