how to enforce job security

[mindless]

hi all

I'm trying to set job security. I have some developers working on the server and I want them to see the jobs, see job history and alter jobs, but only "their" jobs. Is this possible on sqlserver2000.

tia

Zarko

[MAK]

sp_addlogin 'a','a','master'
go
sp_addlogin 'b','b','master'
go

login as 'a' and create a job

login as 'b' and create a job

a cannot see 'b's job and other jobs
created by sa and other users.
b cannot see 'a's job and other jobs created by sa and other users.

login as 'sa' you can see all the jobs.

As 'sa' you can start their jobs and 'a' can see the job was run by 'sa' in the job history.

[mindless]

thanx but I wasn't precise enough, I have groups of users

sp_addlogin 'a','a','master'
go
sp_addlogin 'b','b','master'
go
sp_addlogin 'c','c','master'
go

login as 'a' and create a job

login as 'b' and create a job

login as 'c' and create a job

I want:
user a to see jobs created by a and b
user c to see jobs created by c only

tia

Zarko

[skhanal]

You can create a windows group with ab in one group and c in another, then grant sql server acccess to those windows groups.

[MAK]

Ditto.