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

USER is correct! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Wed, 19 Jun 1996, Koen Van der Elst wrote: } >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 } } }