Re: sysadmin priveledges

From: Sanjay (Sanjay_at_discussions.microsoft.com)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 15:01:29 -0700

Is there any documentation available on TargetServers Role

Thanks

"Russell Fields" wrote:

> Put them in the TargetServersRole in msdb. They will be able to view all
> jobs and history, but not to create or modify jobs.
>
> Russell Fields
> "Sanjay" <Sanjay@discussions.microsoft.com> wrote in message
> news:3FF14EF0-E037-48ED-8259-7FBFFEFDBDDC@microsoft.com...
> > HI All
> > i have a problem which i am sure must be a comon one
> >
> > I want to remove sysadmin priveledges for a lot of users in my system
> > I still want them to be able to view all Jobs under SQL agent and see
> history of jobs
> > How do i do the above
> >
> > Thanks
>
>
>

Relevant Pages

  • Re: California Unemployment hits record 11.5%
    ... sector jobs, Chrysler, GM and California have gone bankrupt and America has the biggest deficit in its history. ... eliminated captial gains taxes and worked with the private sector to increase business investment and to create more jobs. ... Obama declared war on the private sector, raised taxes on businesses and corporations and ran up the biggest deficits in American history. ... The sad fact is Obama's massive deficit spending, combined with his refusal to drill for American oil and his "cap and tax " energy policy will cripple our economy for years to come. ...
    (rec.gambling.poker)
  • Re: Missing History for Jobs (msdb.dbo.sysjobhistory)
    ... If the rows are still in sysjobhistory then they should connect to the jobs. ... If the jobs will not show history further back than 11/24, ... make sure that your SQL Agent Properties - History settings are the ...
    (microsoft.public.sqlserver.security)
  • Re: Programming PowerPC on Mac
    ... > the world was ready for Jobs' vision. ... I.e. you're viewing history through NeXT-tinted glasses and have ... one Marine noticed one of the prisoners was still breathing. ... He faking he's fucking dead." ...
    (alt.lang.asm)
  • Re: Reagans Asst Treasury Sec. Says Land of Opportunity is History
    ... By Paul Craig Roberts ... offshoring of US jobs dismantles the ladders of upward mobility for US ... Mr. Roberts needs to study his history. ... So what is so peculiar about a cab driver in LA, ...
    (soc.retirement)
  • Re: Cant hack it as a gym rat anymore....
    ... My argument is rather that 1) liberal arts degrees aren't a ... As you say, there aren't many "historian" jobs out there, but there are ... The history majors I ...
    (rec.climbing)