DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2000

    How do I exeute a stored procedure in the executor's security context in Oracle

    For example,
    I have a schema ECOMMERCE with table1, table2 and a procedure proc1.

    Proc1 may select, insert or update table 1 and table 2 based on input parameter.

    I created another user APPUSER which only has select rights for table1 and table2. I grant this user the rights to execute ECOMMERCE.proc1

    When I login to Oracle as APPUSER and execute proc1 with parameters to insert rows into table1 and table2, the rows are inserted.

    It seems to me that when APPUSER executes the procedure proc1, the Oracle use ECOMMERCE's security context instead of APPUSER's security context.

    Is there a way to turn this around in Oracle 8i? I want APPUSER to ble able to only select from table1 and table2 through the procedure proc1 without rewriting the procedure.


  2. #2
    Join Date
    Nov 2000
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.