Answered Questions

  • Jun 10 2008
    05:55 AM
    1818
    3

    Schema Procedure and Data

    • shanthiavari

    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?

    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.