Rename table should allow this.
Wayne E. Martin
Informix Database Administrator
Kmart Corp.
-----Original Message-----
From: Prasad Mahale [mailto:gs0528@hotmail.com]
Sent: Friday, September 29, 2000 2:37 PM
To: informix-list@iiug.org
Subject: Changing ownership...
Hi All,
I want to change ownership of some of the tables in my database. The way i
know is by recreating the table with new ownership info. This does'nt look
easy considering my database size.
Is there any easiest way, any tricks (any script?) to do this?
Thanks in advance
-Prasad
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
↪ replying to Martin, Wayne E.
Nope...RENAME TABLE is not for changing table ownership...I think
you'll even get an error if you trying putting "owner." on the new
table name.
--Chuck
On Mon, 2 Oct 2000 09:59:02 -0400, "Martin, Wayne E."
<WMartin@kmart.com> wrote:
>Rename table should allow this.
>
>Wayne E. Martin
>Informix Database Administrator
>Kmart Corp.