Re: processadmin role
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/08/04
- Next message: Doug: "sql always using page file"
- Previous message: anonymous_at_discussions.microsoft.com: "Scripts for Indexes and Constraints"
- In reply to: Sanjay: "processadmin role"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 8 May 2004 10:16:17 +0530
Hi,
Process admin Role
---------------------
Members of Processadmin role can only kill a process. Although the
description for this role says that members can manage
the processes running in SQL Server, the only management option they have is
to kill a process.
By giving the process admin job the users cant execute or see the status of
SQL Jobs.
To view the history of job, DBA can assign the execute prev on
"sp_help_jobhistory" in MSDB database to the user.
To view the job status a normal user can execute the procedure "sp_help_job"
(When the user is not a member of the sysadmin group, sp_help_job will
impersonate the SQL Server Agent proxy account,
which is specified using xp_sqlagent_proxy_account. If the proxy account is
not available, sp_help_job will fail.)
Execute a Job:
sp_start_job
Execute permissions default to the public role in the msdb database. A user
who can execute this procedure and is a member of the sysadmin fixed role
can start any job. A user who is not a member of the sysadmin role can use
sp_start_job to start only the jobs he/she owns.
Thanks
Hari
MCDBA
"Sanjay" <sanjayg@hotmail.com> wrote in message
news:9F863661-784C-45D7-AD32-AE86C88E5493@microsoft.com...
> I need a mamber of my team to monitor some jobs set up by a DBA using SQL
Jobs
> I dont want to give him sysadmin prviledges
>
> He should be able to see the job history and re-run the job if it fails
> Should i give him processadmin role
>
> what does processadmin role exactly do
>
> Thanks
- Next message: Doug: "sql always using page file"
- Previous message: anonymous_at_discussions.microsoft.com: "Scripts for Indexes and Constraints"
- In reply to: Sanjay: "processadmin role"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
