Re: changing table ownership

In-Reply-To: <1ug5u3INN3r1@emory.mathcs.emory.edu> karla@group1.com (Karla Leibowitz) In <1ug5u3INN3r1@emory.mathcs.emory.edu> Karla Leibowitz asks: > I need to change permissions on some tables in our database. When the > database was set up tables were added by several users, and so they > have different owners, one of whom is no longer at the company. I would > like to change the ownership of all tables to one user, because I can not > guarantee that any of the staff will be here forever and because permissions > can not be changed except by the original owner. How can I change the owners > without dumping out the entire database? One nice and simple way is to log on as user informix and then run the following: update systables set owner = "informix" You may also want to do the same for sysindexes. There may be a couple of other tables to; syssynonyms springs to mind. ***************************************************************************** * Stuart Hemming, Tudor Labels Ltd, Roman Bank, Bourne, Lincs, PE10 9LQ. UK * * shemminga@cix.compulink.co.uk uunet!cix.compulink.co.uk!shemminga * * Tel : (+44) 778 426444 Fax : (+44) 778 421862 * ******************** PGP 2.2 sig available on request ***********************