Re: How do I change Table ownership

Posted in 1996

Sanjay Kumar — 8 Apr 1996 11:03:17 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi Jenifer, ______________________ u wrote ________________________________________ I am trying to find an easy way to change the ownership of a large number of tables to a single owner. Is there anyway to do this short of unloading the tables, droping them, then creating them under the new user? U can update the system tables in the database such as systables, sysindexes, syssynonyms, syssyntables, sysconstraints, etc. U can update these tables in your databases. HTH ____________ Sanjay Kumar Email: skumar@raileurope.com Rail Europe Inc. 226 Westchester Ave | Office : (914) 681 3296 White Plains, NY 10604 | Fax : (914) 682 5236