Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

execute permission Expand / Collapse
Author
Message
Posted Monday, October 13, 2008 5:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 14, 2008 3:31 PM
Points: 3, Visits: 22
On a button click event a sql server agent job has to be started. the stored procedure sp_start_job starts the job. It does not work for a non-admin user. I do not want to give them execute permission for sp_start_job because they coould start any job they want to. Can I give permission to a specific job?
Post #585156
Posted Monday, October 13, 2008 9:26 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:07 PM
Points: 2,989, Visits: 2,588
A user is normally allowed to start jobs that the user owns. This is the simplest option although it may not be an option if more than one non-admin needs to be allowed to start the same job.

The only other option I can think of is to
- create a table that is used to indicate whether the job needs to run
- create a new job that runs frequently and checks the above. If the job in question should be run, start it and then clear the flag in the new table.

Then update the code in your application so that instead of starting the job, it simply updates a table.



Post #585193
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse