Home Forums SQL Server 2008 SQL Server 2008 - General Give access to SQL Server Agent ONLY? RE: Give access to SQL Server Agent ONLY?
rajeshsdba
SSC Veteran
Points: 210
More actions
April 16, 2013 at 2:24 am
#1606733
Hi ,
Yes, you can give the permission only for sql agent.
Login with SSMS with sa and creat a user.
select the MSDB and seleect SQLAGENTOPERATORROLE, SQLAGENTREADERROLE.
RAJESH SINGH
DBA.
HCL COMNET
Rajesh SinghDBA(HCL Comnet)+91-0560888360