触发器两个表增删改

CREATE OR REPLACE TRIGGER indoor
  after insert or update or delete on partner_dev.room_resource

  for each row
begin
  if inserting then
    insert into partner_dev.re_indoor
      (name，
       wlzz,
       id)
    values
      (:new.name,
       :new.lc,
       :new.wlzz,
       :new.id);
  elsif updating THEN
    update partner_dev.re_indoor
       set name                = :new.name,
           lc                  = :new.lc,
           wlzz                = :new.wlzz
     where id = :old.id;
  elsif deleting then
    delete from partner_dev.re_indoor where id = :old.id;
  end if;

end;

oracle授权表的权限给某个用户

grant select,insert,update,delete,all on 表名 to 用户

比如：jmml用户把sys_users表的查询权限给jwwl用户

先连接jmml用户，再执行下面的

grant select on sys_users to jwwl

然后就可以用jwwl用户连接测试了

select *  from jmml.sys_users

如果要授权某个用户下面的所有表给user1，建议先用下面的sql，查询出授权拼接的sql执行一下：

select 'GRANT SELECT ON ' || table_name || ' to user1;'  from user_tables