Re: Change owner

Posted in 1996

Jonathan Leffler — 2 Jan 1996 21:33:04 -0500 — source: Informix-list mailing list archive (1991-1998)

>From: Sally Woolrich <Sally@excelsis.demon.co.uk> >Date: Tue, 02 Jan 96 11:19:28 GMT >X-Informix-List-Id: <news.19991> >In article <4c7ofb$ps7@cssun.mathcs.emory.edu> > johnl@informix.com "Jonathan Leffler" writes: >> >How to change owner of a table ? >> There is no official way to do it (apart from drop and recreate). >> Unofficially, suitably authorised users can update the Owner column in >> SysTables (and possibly SysIndexes, SysConstraints, etc.). >Is it also necessary to alter the UNIX owner of the actual >'.dat' & '.idx' files (if running SE)? Yes, if you don't want the original owner to be able to trash the files for you in a fit of pique when they find they no longer own the table. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>