Re: processadmin role

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/08/04 

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

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: Intelligent life form
    ... >>> to attack and possibly kill other members of their own species who ... Many animals kill members of their own species. ...
    (talk.origins)
  • Re: Stealth jihad in the Senate
    ... is with the claim that President Obama and other members of the US ... are so ignorant about the threat of sharia and the stealth jihad ... Journalists put out some guidelines for journalists and reporters ... people to kill. ...
    (soc.culture.jewish.moderated)
  • Re: Stealth jihad in the Senate
    ... is with the claim that President Obama and other members of the US ... are so ignorant about the threat of sharia and the stealth jihad ... Journalists put out some guidelines for journalists and reporters ... people to kill. ...
    (soc.culture.jewish.moderated)
  • Re: Intelligent life form
    ... Many animals kill members of their own species. ... We humans, however, seem particularly adept at it. ...
    (talk.origins)