Execute shell script within Oracle 11g using Scheduler
Bonjour Community,
I have a script that dump certain schema from production database and then reload said data to the dev database. To do that, I'm using a shell script that I want to be lauched, on command, from the user, it seems the most recommended method to fire shell scripts, from what I read anyway.
The problem is, to lauch an "EXECUTABLE" type of scheduler job, the user need the "create job" and "create external job" privileges. From where I stand, I could make a LOT of mess with such privileges, create job that generates script that could make a lot of damage!