- Newest
- Most votes
- Most comments
Hello,
The Master user should be able to perform the restore database without any issues or additional grants. Please check for any syntax issues in the restore command or would it be possible to post the IAM role & policy created hiding the sensitive info.
Whether the master user is AD authenticated or sqlserver authenticated ?
If still doesn't works, then please create new login as below and try the restore
USE master
GO
CREATE LOGIN rds_backup_operator WITH Password = 'complexpassword', DEFAULT_DATABASE=master, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE msdb
GO
CREATE USER rds_backup_operator FROM LOGIN rds_backup_operator
GO
GRANT EXECUTE ON msdb.dbo.rds_backup_database TO rds_backup_operator
GO
GRANT EXECUTE ON msdb.dbo.rds_restore_database TO rds_backup_operator
GO
GRANT EXECUTE ON msdb.dbo.rds_task_status TO rds_backup_operator
GO
GRANT EXECUTE ON msdb.dbo.rds_cancel_task TO rds_backup_operator
GO
Relevant content
- asked 4 months ago
- Accepted Answerasked 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago