Re: permissions

>From: uunet!hector.cc.bellcore.com!warren (saccente,warren j) >To: informix-list@rmy.emory.edu >Date: 24 Mar 1992 10:38 EST >Subject: permissions >Message-Id: <199203241552.AA21274@tbird.cc.bellcore.com> >X-Informix-List-Id: <list.993> > >Re: Informix Online 4.0 Answer applies to all Informix engines, in all releases. >Does anyone know if there is any way that I can: >(1) prevent a user that has dba on the database from updating a particular > table/view? ********************************************************* ** DBA privilege in Informix == ROOT privilege in Unix ** ** You can't stop root! You can't stop DBAs!!! ** ********************************************************** If you don't want a user to do something, that user had better not be a DBA. DBAs are, by definition, trusted users. >(2) prevent the creator of a table/view from updating that table/view? No. The owner of a table may drop the table at any time. The owner of a table may do anything with that table. If you don't want someone fiddling with a table, they had better not own that table. If you need to change the table ownership, you can update the Systables.Owner column as informix (all releases) and as person who created database (DBA with priority 9) in pre-4.0 releases. WARNING: I don't know whether this is officially approved by Informix -- but it normally works. Yours, Jonathan Leffler (johnl@obelix.informix.com)