2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
- The RDS SQL Server system database maintenance job runs DBCC CHECKDB on the system databases (master, msdb, rdsadmin, mssqlsystemresource and model) every day.
- The system databases are managed by AWS, so the DBO role of them cannot be granted to the user logins.
- SSISDB is regarded as a system database, that is why we cannot grant dbo role to another customer logins.
- But it is missing in the daily RDS SQL Server system database maintenance job currently.
- The above information means that DBCC CHECKDB cannot be run on SSISDB at this stage.
- The fix is being worked out, once it is ready, SSISDB will be included in the daily system database maintenance job.
répondu il y a 10 mois
0
It is not currently possible to run DBCC CHECKDB on SSISDB in RDS SQL Server as users are not allowed db_owner permission on SSISDB.
The same holds true for [rdsadmin_ReportServer] and [rdsadmin_ReportServerTempDB].
répondu il y a 10 mois
Contenus pertinents
- demandé il y a un an
- demandé il y a 7 mois
- demandé il y a 3 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- Comment puis-je dupliquer ou cloner mes autorisations de connexion utilisateur RDS pour SQL Server ?AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans