Ir al contenido principal

Entradas

Mostrando entradas de junio, 2014

Select permission denied on teh object sys.... database msdb schema dbo

The SELECT permission was denied on the object 'sys...', database 'msdb', schema 'dbo'. When we try to access the SQL Server Agent related system tables , The following Error occurred Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'sys...', database 'msdb', schema 'dbo'. What are the Database role needed to access the following SQL Server Agent system tables ? USE MSDB Go The following system tables needed SQLAgentOperatorRole database role sysalerts, sysnotifications, sysoperators The following system table needed SQLAgentUserRole database role syscategories The following system tables needed TargetServersRole database role sysdownloadlist, sysjobs, sysjobservers, systargetservers, syssubsystems The following system tables needed db_Owner database role sysjobactivity, sysjobhistory, sysjobschedules, sysjobsteps, sysjobstepslogs, systargetservergroupmembers, syst