-- DROP sequence lxf_id_seq;
创建一个sequence序列,因为oracle不像mysql那样可以id自增:
CREATE OR REPLACE TRIGGER BeforeTestCreate2Insert
BEFORE INSERT ON security_role_privilege
FOR EACH ROW
BEGIN
SELECT lxf_id_seq.nextval INTO :new.id FROM dual;
END;
批量插入sql:(这里是整理了权限表的所有权限后,将role_Id为1的角色赋予权限表所有的权限)
insert into security_role_privilege(role_id, privilege_id) select 1, id from security_privilege;
记下备用。