The trigger below will check to see that user George is only changing his own password and not trying to change other peoples passwords. create procedure reset_password (p_username in varchar2, p_password in varchar2) as begin if (USER=’GEORGE’ and p_username in