Re: Changeing ownership of a database, and related tables

Tony, Create a screen of the systables table and use ISQL to browse, query, etc the tables you want to change ownership. You'll have to be login informix I believe to actually update the ownership. You might want to create screens of the other system tables and do some browsing to learn more about what's in the system tables. But from what I've been reading do take care--some of the tables apparently are not always reporting what they should. I run UPDATE STATISTICS as often as possible to make sure, but even this may notbe enough. You probably won't be able to use the Form option in ISQL to generate your default screens of the system tables, so you'll have to create them with a shell script screen generator of some sort. It'll be educational to say the least. Best Wishes, Tim Schaefer The Computer Business Co. TBSchaefer@aol.com inxutil@aol.com