Home Forums SQL Server 2008 SQL Server 2008 - General Give access to SQL Server Agent ONLY? RE: Give access to SQL Server Agent ONLY?

  • 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 Singh
    DBA(HCL Comnet)
    +91-0560888360