I'm enclosing the trigger code I wrote:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
create or replace trigger LOGG_TRAIL before alter on database when (ora_dict_obj_type = 'USER' and ora_dict_obj_name != user and sys_context('USERENV','ISDBA') = 'FALSE' ); declare by_user varchar2(30); to_user varchar2(30); vprofile varchar2(30); begin select to.PROFILE into vprofile from DBA_USERS by, DBA_USERS to where by.USERNAME = user and to.USER_NAME = ora_dict_obj_name and by.PROFILE = to.PROFILE; insert into TRAIL_TEMP (USER_ALTERED, PASSWORD_MODIFIED_BY, PASSWORD_MODIFIED_DATE, PROFILE) values (ora_dict_obj_name, user, sysdate, vprofile); exception when others then raise_application_error (-20001,'can''t alter user'); end; /This gives errors. Can you please check it? Your help will be highly appreciated.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.