Re: Help!!, Can a trigger be written to prevent INSERTS based on username?

Posted in 1996

Koen Van der Elst — Wed, 19 Jun 1996 20:56:29 GMT — source: Informix-list mailing list archive (1991-1998)

>Can we write triggers which inhibits users with name beginning "xx" from >performing inserts, updates, or deletes on certain tables? > >How do you get the username in a trigger? Doesn't the SQL constant USER do the job ? A trigger is part of a transaction performed by a user, identified by USER (I think). Koen