Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
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?
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