Automate sql login creation using Jenkins

---

---

This task involves updating and automating the password rotation and SQL login creation processes for SQL servers using Jenkins jobs. The steps include: - Pre-Requisite Updates: Revise the Jenkins job responsible for SQL Server password rotation by eliminating few parameter that are not needed anymore. - Ensure the job sets passwords only if the secret key for the login does not exist or if the login is disabled. - Log the enabling of previously disabled logins in SQL Server. Proposed Changes for Automating Login Creation and Rotation:Developers submit a ticket for new service login requests, which DBAs must approve. - Develop Jenkins jobs to provision two SQL logins (GREEN and BLUE) with the required permissions. - Ensure logins are created in lowercase and handle scenarios where logins already exist. - Automate the setting of passwords and generation of secret keys. - Provide the secret key names as output for developers. Password Rotation Process: Developers initiate the Jenkins job to reset the password for the currently disabled login. - Update their services to use the new login within a 7-day window. - DBEs will automatically disable the previously active login after the 7-day period.

Keyword: java

Price: $10.0

Microsoft Windows Git Automation SQL