oracle建立触发器

1 建用户授权

授权角色resoure connect 

授权功能

grant create any table to user_name; 

grant create any trigger to user_name;

主要是解决不能在sys用户下建立触发器的问题

2 表空间权限

normal登陆提示对表空间没有权限

alter user user_name quota unlimited on tablespace_name;

示例

create table EMP1

(

  EMPNO    NUMBER(4),

  ENAME    VARCHAR2(10),

  JOB      VARCHAR2(9),

  MGR      NUMBER(4),

  HIREDATE DATE,

  SAL      NUMBER(7,2),

  COMM     NUMBER(7,2),

  DEPTNO   NUMBER(2)

)

create table emp1 as select * from emp

truncate table emp1

create sequence seq_emp1

start with 1

increment by 1

maxvalue 9999999

cycle;

create table emp1_log

(

act_id number(7),

act_time date,

act_descption varchar2(20)

);

create or replace trigger t_emp1

after insert on emp1

for each row

begin

insert into emp1_log values

(seq_emp1,nextval,SYSDATE,'Inseted ok!');

end;

create sequence seq_emp1

start with 1

increment by 1

maxvalue 9999999

cycle;

create table emp1_log

(

act_id number(7),

act_time date,

act_descption varchar2(20)

);

create or replace trigger t_emp1

after insert on emp1

for each row

begin

insert into caonima1_log values

(seq_emp1,nextval,SYSDATE,'Inseted ok!');

end;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25188158/viewspace-734910/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25188158/viewspace-734910/