CREATE OR REPLACE TRIGGER trg_dropdeny
BEFORE
DROP OR TRUNCATE
ON DATABASE
BEGIN
IF sys.login_user<>'SYSTEM' and sys.login_user<>'SYS'   THEN
raise_application_error(num => -20000,
                          msg => 'are you creay,you really want delete or truncate this table ' || ora_dict_obj_name() ||
                               ' ？' || '........................');
END IF;
END;
/

ITPub博客

防止普通用户drop and truncate table

最新文章