oracle 里面限制某个用户不能更改表里面的某个字段的触发器该怎么写
比如用户011 不能更改tb 表里面的name字段该怎么写这个触发器？
[解决办法]

CREATE OR REPLACE  TRIGGER TEST
BEFORE  UPDATE OF name
ON tb FOR EACH ROW
DECLARE
  L_USERNAME VARCHAR2(100);
BEGIN
  SELECT T.USERNAME INTO L_USERNAME FROM USER_USERS T;
  IF L_USERNAME = '011' THEN
    DBMS_OUTPUT.PUT_LINE('YOU CAN NOT UPDATE THE COLUMN');
    ROLLBACK;
  END IF;
END;

create or replace trigger test_trig 
before update on tb
declare
user varchar2(10);
begin
   SELECT SYS_CONTEXT('USERENV','SESSION_USER') into user from dual;
   if user='011 ' and updating('name') then
      raise_application_error(-20001,'not allow change'
   end if;
end;