Re: SQL job owner and right

Sorry. I just confirmed that we only have SQLAgentUserRole. That's the
reason I couldn't see the job which is created by account A.

Again, more than 2 people will manage same jobs for application, but not the
jobs related to server maintainance. Reader and Operator role won't fulfill
this right as well. What's the best practice for this situation.

Thank you again.
--
Best Regards,

Lynn


"Lynn" wrote:

We are in SQL 2005 and my account is already granted all those three roles
and account A also has these three roles. But, I can't see the job that
account A created.

What's the best practice to archive -- multiple accounts can manage SQL job
without sysadmin right?

Thank you again.
--
Best Regards,

Lynn


"Andrew J. Kelly" wrote:

If you are using SQL2000 then you need to be sa. In 2005 there are 3 new
roles that define the abilities of non-owners in SQL Agent. Check out these
in BooksOnLine for more details:

SQLAgentUserRole

SQLAgentReaderRole

SQLAgentOperatorRole

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Lynn" <Lynn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1AE16035-2A1A-4252-A978-196C53ED16C4@xxxxxxxxxxxxxxxx
Hi,

A user has right to create and operate a SQL job, but only limited to the
jobs that this user is created. Without granting sysadmin right, how to
grant a user to be able to operate and change the job which is created by
other users?

Thank you.
--
Best Regards,

Lynn


.

Relevant Pages

  • Re: SQL job owner and right
    ... If you trust these users enough to let them do anything they want to any of those jobs then you can trust them to login with that account when editing jobs. ... Andrew J. Kelly SQL MVP ... try to assign the job owner to this group, but the window group is not ... I just confirmed that we only have SQLAgentUserRole. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL job owner and right
    ... By "Operate and Change" the job do you mean edit what the job does or just when it runs? ... and account A also has these three roles. ... > SQLAgentUserRole ... > Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.security)
  • File Permissions for BCP job
    ... You have to make sure that the SQLServerAgent Service is ... change the owner to this account) to run as the same user. ... On the other file server, ... >server to BCP running as a SQL job on another SQL server ...
    (microsoft.public.sqlserver.security)