For 3), you might hit a problem with executing PL/SQL. The error is
PLS-00201 which appears to be related to bug 1724703 with
current_schema. The workaround is to create a public synonym.
Magaliff, Bill wrote:
I'm writing a stored procedure to be run by the dba. I want to provide the
I'm writing a stored procedure to be run by the dba. I want to provide the
ability to manipulate data from a schema specified at runtime. I have the
schema owner as an input variable, but I see three possible way to do this:
1) have the dba verify that all necessary DML privs on that