Post reply

How Non sysadmin Users enable Job schedule

  • October 8, 2009 at 4:57 am

    #205423

    Hi experts,

    Our business requirement is that, they want on demand scheduling of a Job, There is a Application User (TASuser - sql login) wants to enable job schedule so that they can run the job whenever they want.

    In 2005 I found that there are fixed SQL Agent Roles (SQLAgentUserRoles, SQLAgentReaderRoles) so I added TASuser login in MSDB database & given these roles (SQLAgentUserRoles, SQLAgentReaderRoles, TargetServerRole) & its working fine, But there is concern about security, Is this secure?

    My questions is about security, Is this secure? or Is there any other way we can do the same thing in sql server 2005?

    Thanks,

  • October 8, 2009 at 2:38 pm

    #1063748

    I only use the SQLAgentUserRole in one situation and it seems secure enough, even though I have a proxy assigned to it. I think it's safe as long as the SQL login's password is secure.

    One note: according to BOL, SQLAgentReaderRole members are automatically members of SQLAgentUserRole so you don't have to explicitly make a user a member of both roles, just SQLAgentReaderRole.

    Greg

  • October 13, 2009 at 1:58 am

    #1065074

    Hi Greg,

    Your reply gave me confidance!

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply