Re: Table Ownership, Changing

Posted in 1994

Elfers,Peter,70252,E,940323,000000, — 11 Aug 1994 08:26:35 +0200 — source: Informix-list mailing list archive (1991-1998)

In <1994Aug9.171507.11771@anasazi.com> brian@anasazi.com (Brian Lee) writes: >Hi- >I am looking for ideas on changing table ownerships. What I need to do is >change the ownership of all the tables in my database. >Does anyone have any comments on this subject? >Thanks, >Brian Lee How about loggin in as user informix, use isql (or make a sql-script): update "informix".systables set (owner) = ("desired_owner") where tabtype = "T" or tabtype = "V"; This should alter the owner for all tables and views and not for synonyms. Hope it works (I have not tested it !!) Peter