Permissions in Enterprise Manager

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  December 6, 2004 at 5:38 am

  #532614

  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

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  December 6, 2004 at 10:17 am

  #532697

  Check the role TargetServerRole in msdb. This should give you permissions to view the jobs.

• Bill Geake

  Ten Centuries

  Points: 1352

  More actions

  December 9, 2004 at 4:12 am

  #533156

  Many thanks - this is the solution. A whole team of developers is grateful (and one DBA).

  Anothe win for SQL Server Central!