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

Re: 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: Thu, 26 Nov 1998 09:59:41 +1100
Message-ID: <revdoc-2611980959410001@bastardo.its.uow.edu.au>

In article <ADpKzMsK42_at_protasov.kiev.ua>, oracle_at_protasov.kiev.ua wrote:

> Is this the thing you want?
>
> [100% correct working solution snipped]

Kudos to Andrew Protasov and those who replied in email (you know who you are :) CREATE ANY SYNONYM was the exact incantation that I needed. Thanks to all.

Phil.

Received on Wed Nov 25 1998 - 16:59:41 CST

This message: [ Message body ]
Next message: Uday Bikkasani: "Re: How to start and stop the listener service from Dos prompt ?"
Previous message: Uday Bikkasani: "Re: How to configure WebView ... or use WebServer 3.0"
In reply to: Andrew Protasov: "Re: How can I create an object in one user's schema using a stored procedure owned by another user?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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