Re: Jobs and permissions policy

From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 15:26:12 -0400

Mark,

You can give the rights to modify the job for the user who 'owns' the job.
Being dbo in your respective database is not enough. This means that any
job can only be maintained by one person. (Unless you have a service login
that owns the job and give the password to that login to several people.)

Russell

"MarkR" <mrussell@dasny.org.dontspamme.net> wrote in message
news:OUrVOyILEHA.556@TK2MSFTNGP10.phx.gbl...
> Other than giving programmers/developmentstaff sa permissions, what is the
> recommended way to give these folks, who are dbo in their respective
> database the ability to see and modify jobs ..(targetservesrole is just to
> view and execute right?)? I only come up with giving them SA and that
> really is not a good answer. Any thoughts on this would be
> appreciated...thanks..
>
>

Relevant Pages

  • Jobs and permissions policy
    ... Other than giving programmers/developmentstaff sa permissions, ... recommended way to give these folks, who are dbo in their respective ... database the ability to see and modify jobs ..(targetservesrole is just to ...
    (microsoft.public.sqlserver.security)
  • Re: Change dbo
    ... I have a database where a user is defined as the dbo on a database. ... I tried using SQL Server Manger ... The login for this person maps to dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: Groups for dbo
    ... Thanks for the instructions on changing the database owner...I suspect ... While dbo is SUPPOSED to be a special user that's not used for routine ... It's probably safer to change the database owner in any event, ... >> I'm still fairly new to SQL Server, and I'm trying to figure something ...
    (microsoft.public.sqlserver.security)
  • Re: Change UDF Owner
    ... system_function_schema -especially in the master database. ... Most good judgment comes from experience. ... dbo is in the context of a database, and can be the schema owner for the ... Users can be put in the dbo role, ...
    (microsoft.public.sqlserver.security)
  • Re: Change dbo
    ... I have a database where a user is defined as the dbo on a database. ... I tried using SQL Server Manger ... The login for this person maps to dbo. ...
    (microsoft.public.sqlserver.security)