Changing ownership...

Posted in 2000

Prasad Mahale — Fri, 29 Sep 2000 18:36:38 GMT — source: Informix-list mailing list archive (1991-1998)

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 Prasad Mahale

Sally Woolrich — Tue, 3 Oct 2000 17:01:04 +0100 — source: Informix-list mailing list archive (1991-1998)

On Fri, 29 Sep 2000 19:36:38 +0100, "Prasad Mahale" <gs0528@hotmail.com> wrote: > >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 If you are using SE it's quite easy. Working as 'informix' update systables.owner to the new owner, and also remember to alter the Unix owner of the .dat and .idx. :-) However OL / IDS is a different beast. :-(