RE: Changing ownership...

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.

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.