Procedure security
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Procedure security

  1. #1
    Join Date
    Sep 2000
    Posts
    7
    Hi,

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

    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.

    Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    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