Resetting the db_owner role password - Amazon Relational Database Service

Resetting the db_owner role password

If you lock yourself out of the db_owner role on your Microsoft SQL Server database, you can reset the db_owner role password by modifying the DB instance master password. By changing the DB instance master password, you can regain access to the DB instance, access databases using the modified password for the db_owner, and restore privileges for the db_owner role that may have been accidentally revoked. You can change the DB instance password by using the Amazon RDS console, the AWS CLI command modify-db-instance, or by using the ModifyDBInstance operation. For more information about modifying a DB instance, see Modifying an Amazon RDS DB instance.