September 10, 2010     |
Network Toaster
SQL Security Forums
Note: SQLSecurity.com does not allow nor require registration due to privacy concerns for users. SQLSecurity.com is open and anonymous for all. Please report any abuse or profanity.
Subject: Browse access to EM\Management\Jobs
Prev Next

Author Messages
John

10/10/2003 4:52 PM Quote Reply Alert 
It would be beneficial to our Developers if they could browse (only) the Properties & View Job History of the Jobs THEY (only selected jobs) are responsible for in Enterprise Manager \ Management \ Jobs. Is it possible to grant such access? My justification: When our apps ran on the mainframe, it's mandatory for the programmer to have access to the jobs. They could browse the JCL and view all of it's output after it runs. When the job abended, they needed to see the output to troubleshoot. Well, now that the "system" has migrated to client/server (SQL), they need the same capabilities. Any suggestions or tips is greatly appreciated!
Chip Andrews

10/13/2003 2:03 PM Quote Reply Alert 
Are you trying to stop them from executing jobs? You could always revoke 'public' role execute rights to the msdb.dbo.sp_start_job procedure (and the sp_stop_job procedure while you're at it). Chip
John

10/14/2003 8:21 AM Quote Reply Alert 
I do not want them to execute jobs. The programmers currently do not have access to display any Jobs in Management\SQL Server Agent. What I would like to do (if possible) is to give them access to browse the Jobs that are setup (preferbly their own jobs - which I know I am even asking more here. Example: We may have Accounting jobs and Payroll jobs setup on a server. I want the Accounting programmer to only see the Accounting jobs.). I want them to see the Properties & View Job History. I do not want them to have the ability to modify anything in Jobs.

Forums > Discussions > SQL Server Security > Browse access to EM\Management\Jobs

Quick Reply
Username:  
Subject:  
Body:
 



ActiveForums 3.6
Copyright 1999 by Chip Andrews   |  Privacy Statement  |  Terms Of Use