How to prohibit certain SQL operations ?

Hi, Thomas! > Hallo everywhere, > > I'm looking for a good way to prohibit certain operations, e.g. I don't want > that a table is manipulated by an UPDATE statement. But the triggers (available > since version 5.0.1) don't allow me to rollback a SQL statement, because the > transaction concept is only available in the embedding SQL programming linke ESQL/C. ^^^^^^^ Are you sure? I'm afraid you are wrong. > When using the BEFORE clause of the Trigger the triggering action (e.g. my bad update) has already occured, this is not desirable. > > Any ideas from the Informix community ? > > --- > Thomas Kudrass > kudrass@dvs1.informatik.th-darmstadt.de I don't understand the reason you avoid using triggers. The other way to prohibit some operations is using VIEW and privileges. You can issue smth like REVOKE UPDATE ON my_table_or_my_view FROM PUBLIC Hope this help. A.G. --------------------------------------------------------------- Andrew Yu. Grachyov | Phone +7 (095) 928-6078 TERN, Moscow, Russia | +7 (095) 925-1785 andy@tern.msk.su | Fax +7 (095) 280-3870