Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.
Amazon RDS MSSQL permissions on the Master database
IHAC running MSSQL 2016 SE in an AWS RDS instance, the customer application requires this permissions on the Master database: Create DB, create DB backup, “grant view”, any definition.
sql_engine_version_2016 = "13.00.6435.1.v1" sql_family_2016 = "sqlserver-se-13.0"
Is that possible to grant this access? He is getting a "permission denied" error using the master user credential. Thank you
- Language
- English
- Newest
- Most votes
- Most comments
Hello,
Of the permissions he's trying to grant, probably the 'backup' one is causing the error. This is because native backups on RDS for SQL Server are done a bit differently, the user needs to call a specific Stored Procedure that will take care of the backup, instead of running the "BACKUP DATABASE" command.
There's a quick article about the steps to do a native backup here: https://repost.aws/knowledge-center/native-backup-rds-sql-server
Relevant content
- asked 2 years ago
