Schema Procedure and Data

Schema A has some objects and created one procedure and granted to Schema B. Schema B has the same objects like Schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B?

Questions by shanthiavari

Showing Answers 1 - 3 of 3 Answers

shuklad

  • Jul 6th, 2008
 

Procedure will be executed with the authority of A and therfore data will go to the tables owned by A. If one wants the data to go to B, use the clause authid current_user while defining the procedure.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions