Oracle概要文件与触发器

最新推荐文章于 2023-01-31 15:50:25 发布

cqwuliu

最新推荐文章于 2023-01-31 15:50:25 发布

阅读量109

点赞数

分类专栏：数据库知识文章标签：数据库

本文链接：https://blog.csdn.net/weixin_44873668/article/details/103820709

版权

数据库知识专栏收录该内容

12 篇文章 0 订阅

订阅专栏


--创建概要文件
CREATE PROFILE "SY_UNLIMITED"
    LIMIT 
	COMPOSITE_LIMIT  UNLIMITED
SESSIONS_PER_USER  UNLIMITED

CPU_PER_SESSION  UNLIMITED
CPU_PER_CALL  UNLIMITED
LOGICAL_READS_PER_SESSION  UNLIMITED
LOGICAL_READS_PER_CALL  UNLIMITED
IDLE_TIME  UNLIMITED
CONNECT_TIME  UNLIMITED
PRIVATE_SGA  UNLIMITED
FAILED_LOGIN_ATTEMPTS  10
PASSWORD_LIFE_TIME  180
PASSWORD_REUSE_TIME  UNLIMITED
PASSWORD_REUSE_MAX  UNLIMITED
PASSWORD_VERIFY_FUNCTION  NULL
PASSWORD_LOCK_TIME  1
PASSWORD_GRACE_TIME  7;


--创建trigger触发器
create or replace trigger plat
  after insert or update or delete
  on plat.appuser
  for each row
declare
       test type_object_checkmain;
begin
  test:=type_object_checkmain(null,null,null,null,null,null);
  
  if inserting   then
    insert into plat.APPUSER_ROLE_REL(roleid,USERID,ISVALID,MODIFYUSER,MODIFIED) values('4EEE344227D5427780FC5103CCB8306E',userid,1,'系统用户',sysdate);
    test.flags:=2;
  test.iid:=:NEW.iid;
  test.senduser:=:new.userid;
  
    else if updating then
    test.iid:=:NEW.iid;

    else if deleting then
    test.iid:=:OLD.iid;
    test.stepid:=:new.isback;
    end if;
    end if;
    end if;
    if test.stepid=0 then
    checkCase.checkMsg(test);
    end if;
end;