Giving developer ability to create a job

  • We have a DBA who needs to create job(s) for the databases he is in charge of developing. He does not have SA privileges. He says when he creates the job when he tries to edit the steps he does not see the database he wants to assign the job to. This must be a permission issue but I am not sure where to look.

     

    Another question - if a user has datareader right by one objects permission (say his user account) and dbo by group membership, will he get dbo?

     

    Thanks in advance!

  • Firstly this is a permission issue. You must have sa rights to execute a any job. the reason why he does not see the databases is because he does not have rights to those databases.

  • Understood, SA to execute jobs. What permissions are needed? He can see other databases  he does not manage but not his own. And he is a user in said database.

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

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