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

Spetc@aol.com wrote: > > Hi all > > We are using Online 5.07. > > 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? > > Thanks in anticipation!! Why don't you revoke privileges from those types of users? Even if you have a lot of them with rapid change, you should be able to put together a utility to maintain them based on the current contents of your /etc/passwd file using nothing more than awk, shell, and dbaccess. -- ------------------------------------------------------------------------------- John Prideaux e-mail: alastl@ix.netcom.com Phone: (217)839-2121 Aladdin Steel, Inc. Fax: (217)839-4327 -------------------------------------------------------------------------------