execute permissions and scheduled jobs
From: jmeyers (jmeyers_at_discussions.microsoft.com)
Date: 10/08/04
- Next message: Mark: "Auditing the sa user?"
- Previous message: Kim Noer: "Server roles?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 8 Oct 2004 07:33:03 -0700
I'm wanting to update a job schedule via making a call to the
sp_update_jobschedule sproc from a table trigger. The problem I'm having is
that when the records are inserted into the table, which in turn executes the
trigger, it's not the database server - it's a web application server where
the CRM application (3-tier) resides.
I've found that the sp_update_jobschedule sproc has execute permissions
explicitly denied to the TargerServersRole. When I remove the explicitly
denied permissions, it works fine. Keep in mind, I didn't grant execution
permissions, just removed the explictly denied permission. What
problems/potential problems may result if the TargetServersRole permissions
are modified in this way on the sp_update_jobschedule sproc? Or, is there
another way to accomplish what I want to do without messing with the
permissions?
- Next message: Mark: "Auditing the sa user?"
- Previous message: Kim Noer: "Server roles?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
