Re: Changing systables.owner

Posted in 1995

Alan Popiel — 20 Apr 1995 10:48:03 -0400 — source: Informix-list mailing list archive (1991-1998)

> Subject: Changing systables.owner > Date: 17 Apr 1995 23:59:57 GMT > Reply-To: Timothy W. Moore <75253.2057@CompuServe.COM> > Organization: via CompuServe Information Service > > Has anyone ever changed the value in the owner field of systables? My > company has different financial applications that share the same database. > We want to write a 4GL program to unload only the tables for a certain > application. The program is to dynamically get the table names from > systables. We are planning to put a two letter abbreviation in the owner > field to help us accomplish this. I have successfully changed owner names in both SE and OnLine databases. You should be user informix or another dba-privileged user when you do this. It is wise to coordinate the owner in sysindexes with the owner in systables, also the grantor column in systabauth and syscolauth. Since you are reorganizing your DB ownership, this might be a good time to switch to defining pseudo-users with dba privilege, one per application, who would own all the tables and indexes for the application and do all the permission granting and revoking. No real users should have dba privilege. Selected users would be given the passwords for the application pseudo-users, so they could perform dba functions. By having to switch users, the people would be reminded which "hat they were wearing". This approach simplifies personnel management, since no real user (who might quit or be fired) would own any database objects. When someone who knows a dba password leaves or changes job within the organization, simply change the dba pseudo-user password. Regards, Alan +---------------------------+-----------------------------------------------+ | R. Alan Popiel | Internet: alan@den.mmc.com | | Lockheed Martin, SLS | Voice: 303-977-9998 | | P.O. Box 179, M/S 3810 | Standard disclaimers apply. Cutesy ones, too. | | Denver, CO 80201-0179 USA | Your mileage may vary. Void where prohibited. | +---------------------------+-----------------------------------------------+