Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Stored Procedure Challenge - solution

Stored Procedure Challenge - solution

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 11 Jun 1999 21:23:49 +0100
Message-ID: <929132838.13724.0.nnrp-01.9e984b29@news.demon.co.uk> 






How do you get a version 7 stored procedure to
execute as the caller, rather than the owner ?



There are (at least) two methods -


    dbms_sys_sql and loopback db links.



Details on my website.



--



Jonathan Lewis


Yet another Oracle-related web site: www.jlcomp.demon.co.uk



Received on Fri Jun 11 1999 - 15:23:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US