Re: Summary: Newbie question: how to change ownership of a table

jgraves_at_eng.auburn.edu (Jeff Graves) writes:

>Original question:
 

>> What is the right/best way to change the ownership of an existing table or other object?
>> I checked my manuals but did not find anything.

For a REAL quick dirty change of ownership, change the owner id in SYS.OBJ$, then bounce the database to put this info up in the SGA.

Unsupported, you need to be SYS to do it, but it works.

Details in the Oracle FAQ and FTP archive, including a script to do it!

--
---
David T. Bath       | dtb_at_ftp.bf.rmit.edu.au (mail=dtb_at_bf.rmit.edu.au)
3/175 Wattletree Rd | Snr Tech Consultant, Global Consulting Services
MALVERN 3144 VIC    | 179 Grattan St, Carlton, Vic 3053, Australia
+61 3 500 9337      | Ph:+61 3 3477511  Fx:+61 3 3470182 Mb: +61 15 824171
WWW pages incl. ORA FAQ: lynx http://www.bf.rmit.edu.au/~dtb