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 -> How can I create an object in one user's schema using a stored procedure owned by another user?

How can I create an object in one user's schema using a stored procedure owned by another user?

From: Phil Herring <revdoc_at_uow.edu.au>
Date: Wed, 25 Nov 1998 17:30:53 +1100
Message-ID: <revdoc-2511981730530001@bastardo.its.uow.edu.au>


The subject says it all!

I would like create some synonyms in user B's schema from a procedure owned by user A. However, when user B executes user A's procedure, it executes in user A's schema, so the synonym is created there, and user B doesn't get the synonym.

RDBMS version is 7.3.3.0.

All suggestions for getting around this will be gratefully received... Received on Wed Nov 25 1998 - 00:30:53 CST

Original text of this message

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