Re: SA Security
You can allow them to see jobs (definition and history) by adding them to
the TargetServersRole in the msdb database. They will not be able to see
whether a job is currently running or not though (although there is a
convoluted way to do that by querying sysprocesses) and they can't modify or
start job jobs they don't own
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Ken Widner" <KenWidner@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:95CA5197-DD6F-4AEE-BA9C-BFE10FDE8C7B@xxxxxxxxxxxxxxxx
Is there a way to give someone in SQL 2000 that isn't an SA the ability to
see jobs when their not the owns of those jobs. Someone told me about
making
a change to one of the Sp's in msdb that would fool the system into things
your in an SA role when your really not. Anyone know anything about
this.?
.
Relevant Pages
- How Someone Can View Jobs in EM That He Does Not Own
... >>he does not own any of the jobs. ... >>grant him a user in the msdb database that has select ... >>privs on all tables and execute privs on all stored ... >>Steve G ...
(microsoft.public.sqlserver.security) - How Someone Can View Jobs in EM That He Does Not Own
... >he does not own any of the jobs. ... >grant him a user in the msdb database that has select ... >privs on all tables and execute privs on all stored ...
(microsoft.public.sqlserver.security) - Re: logs of creating and deleteing jobs
... Jobs are simple entries in the MSDB database, ... want to keep track of that you will either have to tweak the appropiate ...
(comp.databases.ms-sqlserver) - 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) |
|
