RDS and SQL - need to give Login db_datareader to MSDB

0

Fellow RDS/SQL dbas,

I need a login id to have db_datareader access to msdb in RDS.

When I try it, I get: Cannot alter the role 'db_datareader', because it does not exist or you do not have permission.

I am able to do just about anything else on this new rds instance except this. What am I missing? thx MG

1개 답변
0

In Amazon RDS for SQL Server, you do not have sysadmin permissions, so you are not allowed to grant permissions on system databases such as msdb. This is a restriction imposed by the managed nature of Amazon RDS, where certain administrative features are retained by AWS to provide the scalability, reliability, and security features of the service.

For the msdb database, AWS provides a set of stored procedures that you can use to perform the most common tasks, such as managing jobs and schedules. These stored procedures are named rds_msdb, and are located in the rdsadmin

You can read the following link for more information

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.html

profile picture
전문가
답변함 일 년 전
  • HI SDTSLMN,

    thanks for it does not solve the issue.

    I need a way to read the msdb.dbo.sysjobs table and msdb.dbo.sysjobhistory table.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠