December 6, 2004 at 4:54 am
My DBA is having trouble with permissions in Enterprise Manager.
As a developer, I need to be able to look at live systems for support reasons, but not make changes. On a live box, I can't even view the list of SQL Server Agent jobs in Enterprise Manager. I'm a member of a role with select privileges on sysjobs in the msdb database, so can query this, but how can the DBA give me permission to see the jobs (and their logs/history) in Enterprise Manager?
TIA,
Bill.
December 6, 2004 at 5:38 am
They really can't. The way of seeing this in EM is that IF you are the same permission-level or greater THAN you can see through the GUI IF not then you cannot see through EM.
IF you have R/O to the system tables why do you need to see the GUI? The tables are sysjobs, sysjobschedules, sysjobsteps, sysjobservers, sysjobhistory and provide all the same information?
Good Hunting!
AJ Ahrens
webmaster@kritter.net
December 6, 2004 at 10:17 am
Check the role TargetServerRole in msdb. This should give you permissions to view the jobs.
December 9, 2004 at 4:12 am
Many thanks - this is the solution. A whole team of developers is grateful (and one DBA).
Anothe win for SQL Server Central!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply