How can I grant users access to msdb.dbo.rds_drop_database on RDS SQL Server?

Question

Is there a way to grant users, other than the master admin account, access to the drop database proc: msdb.dbo.rds_drop_database on an RDS SQL Server instance?

We've been able to grant backup and restore with the method described here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.DropMirrorDB.html

However, if we try the same with the drop database proc it fails and says we don't have permissions to do this.

Is there some way to delegate access to msdb.dbo.rds_drop_database on RDS SQL Server instances to accounts other than the master admin account?

Ismail_G · Answer

I recently became interested in this topic and looked into it. After testing it myself, I can say that for mirror databases, there is no supported way to allow other users to execute msdb.dbo.rds_drop_database on Amazon RDS SQL Server.
A Lambda function and API Gateway can be used to drop the database, but this is an external workaround rather than a native SQL Server solution.
I’d be happy if someone finds an official method and shares the solution.

How can I grant users access to msdb.dbo.rds_drop_database on RDS SQL Server?

Relevant content