Re: Change owner

Posted in 1996

Jonathan Leffler — 31 Dec 1995 23:38:03 -0500 — source: Informix-list mailing list archive (1991-1998)

>From: Simon Ho <hoksimon@hk.super.net> >Date: 29 Dec 1995 02:19:18 GMT >X-Informix-List-Id: <news.19948> > >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.). Beware of how you revoke the privileges which were granted on the table by the old owner -- WITH GRANT OPTION can make this very tricky to do. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>