Re: RESEND: changing owner of table
From: (wrong string) üis <mabelle_at_bluewin.ch>
Date: 1998/01/27
Message-ID: <01bd2b9f$71316960$d50bbac3_at_m3bj1>#1/1
Date: 1998/01/27
Message-ID: <01bd2b9f$71316960$d50bbac3_at_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 CET