database trigger

I have a table called users with a field that holds an encrypted password 'user_password' and a field that holds the user's name 'user_id'.

This is a generic account in the associated application which needs it's password to remain the generic password, yet, in spite of efforts to the contrary, users in a training class will inevitably change the password and commit.

I want to write a database trigger that will fail the commit when the user_id = 'TRAINING' so the password change does not occur. I may want to give a message and I may want it to be transparent to the user.

I've done a before update trigger, but it isn't trapping the event if I manually try to update the user_password field through sqlplus where user_id='TRAINING'.

Help please!
:)
Got to do this today if possible. Received on Tue Jul 06 1999 - 14:59:30 CDT