MS-SQL Database Static Roles and Credential Rotation

Vault
1

Hi … is this new feature available using ms-sql?

2

Hello - Static Roles are not currently available in MSSQL. Currently the only databases with support for static roles are PostgreSQL, MongoDB, and MySQL.

1 Like
3

OK thanks @catsby … is there a way to know if it will be supported or is on a roadmap of sorts?

1 Like
5

Hello - We can create the static role for MS-SQL with the below script and rotate the password through Vault.

###Create a static role to rotate the password
vault write “database/static-roles/education”
db_name=mssql
rotation_statements=“ALTER login [{{name}}] WITH PASSWORD = ‘{{password}}’;”
username=“test”
rotation_period=86400