Re: Change SP owner

A copy of this was sent to "Amos" <amos_987_at_hotmail.com> (if that email address didn't require changing) On Thu, 17 May 2001 19:38:02 -0200, you wrote:

>Hi,
>Is it possible to change a procedure's owner by SYS and how ?
>
>

No, you have to recreate it. You cannot change the owner of anything.

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:743825617527

for a method to do this via scripts.

>
>Amos.
>
>
>
>

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp