Re: RESEND: changing owner of table

From: Mabel Trigüis <mabelle_at_bluewin.ch>
Date: 1998/01/27
Message-ID: <01bd2b9f$71316960$d50bbac3@m3bj1>#1/1

Hi,

There is no way to change it. You have to recreate your table. If you have data already you can do as follows:

connect owner/password;
grant select on x to owner2;

connect owner2/password2;
create table x
as select * from owner.x;

connect owner/password;
drop table x;

Jose Manuel Araque <araque_at_vin.bellcore.com> wrote in article <34CD04AE.5E8ECD7B_at_vin.bellcore.com>...
> Anyone,
>
> how can I change the OWNER of a table created under Oracle after the
> table was already created? (the owner is set to the login that created
> the table on sys.dba_tables).
>
> Thanks in advance!
>
> jose manuel
>
>
>
>
>
Received on Tue Jan 27 1998 - 00:00:00 CST