Re: Newbie question: how to change ownership of a table
Date: 18 Feb 1995 18:39:29 GMT
Message-ID: <3i5et1$6ra_at_ixnews3.ix.netcom.com>
In <792927855.4725_at_pyra.co.uk> markb_at_pyra.co.uk (Mark Bluemel) writes:
>
>In <D3t6zM.5wz_at_mail.auburn.edu> jgraves_at_eng.auburn.edu (Jeff Graves)
writes:
>
>
>>Hi,
>> What is the right/best way to change the ownership of an existing
table or other object?
>
>You can't, as far as I know. You have to create a new object with the
correct
>ownership, for example (with CREATE ANY TABLE priviledge) :-
>
> CREATE TABLE new_owner.table
> as SELECT * FROM old_owner.table
>
>[Snip...]
>
>I'll be interested to see any other suggestions ...
>--
>Mark Bluemel Unix/Oracle Trainer and Consultant
> My opinions are my own, but I'll share them
> All solutions to problems are offered "as is"
> and without warranty - you have been warned :-)
>
>
You would have to go into the system tables and make changes to the data dictionary. YOU DO NOT WANT TO DO THIS. You could create a new table and then delete the old one. (If they let you). Craig Received on Sat Feb 18 1995 - 19:39:29 CET