CREATE OR REPLACE TRIGGER TR_AUDIT_ALTER
BEFORE ALTER ON DATABASE
BEGIN
IF LOWER(USER) not in ('tjbb11','sys','tjbb12') --只有这几个用户可以执行alter命令,其他用户将被拦截
THEN
raise_application_error (num => -20000,
msg => 'Sorry,You '
|| ora_dict_obj_name ()
|| ' ?!!!!!'
|| 'please contact the DBA'
);
END IF;
END;
BEFORE ALTER ON DATABASE
BEGIN
IF LOWER(USER) not in ('tjbb11','sys','tjbb12') --只有这几个用户可以执行alter命令,其他用户将被拦截
THEN
raise_application_error (num => -20000,
msg => 'Sorry,You '
|| ora_dict_obj_name ()
|| ' ?!!!!!'
|| 'please contact the DBA'
);
END IF;
END;