Why can't user with SQLAgentOperatorRole delete his own SQL jobs I created a login and a user. I assigned the user as the db owner of the database "test". Then I granted him the role SQLAgentOperatorRole so that he can delete/create/modify the jobs belonging to the database "test". But I can only view the jobs though I have granted SQLAgentOperatorRole. What should I do to allow this user to do anything to the jobs belonging to the database "test" ? Please advice.
According to the SQL Server documentation, a user with a SQLAgentOperatorRole can only modify jobs that it created itself.