Re: Changing owner of a table

From: <aldenhoven_at_my-dejanews.com>
Date: Thu, 18 Jun 1998 12:24:53 GMT
Message-ID: <6mb0ul$4c5$1@nnrp1.dejanews.com>

Hi,

the only way I know is an export of these tables. Afterwards you can import these with fromuser='SMITH' and touser='WEBBER'.
The rename command can not change the
owner or tablespace.

Hope that helps
Axel

In article <3588ca08.1313849_at_news.zeitung-online.net>, stefan_at_westner.org (Stefan Westner) wrote:
>
> Hello,
>
> I have greated some tables with the owner 'smith' and want to change
> the owner of all tables from 'smith' to 'webber'. Is this possible?
>
> Thanks
>
> Stefan Westner
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Jun 18 1998 - 07:24:53 CDT