创建触发器权限不足？！

[mary31]

我现在需要的是，在WORKSHEET中创建用户，给用户创建表、创建触发器，现在表创建成功，但创建触发器提示权限不足 ????

Connect system/manager@oradb
drop user BBB cascade;
create user BBB identified by BBB
default tablespace users
temporary tablespace temp
quota unlimited on users;
grant connect to BBB;
grant resource to BBB;
grant create table to BBB;
grant create trigger to BBB;

Connect bbb/bbb@oradb

CREATE TABLE "活动" (
编号 NUMBER (12) NOT NULL,
最后访问时间 DATE,
ID NUMBER (12) DEFAULT 0 NOT NULL)
TABLESPACE USERS
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 131072
NEXT 131072
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 4096
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;

CREATE OR REPLACE TRIGGER "bbb".活动_ID
BEFORE INSERT OR DELETE OR UPDATE ON 活动
FOR EACH ROW
DECLARE
nid NUMBER;
BEGIN
IF INSERTING THEN
SELECT NVL((MAX(ID)+1),1) INTO nid FROM 活动;
:new.ID := nid;

ELSIF UPDATING THEN
:new.ID := :old.ID;

ELSIF DELETING THEN
NULL;

END IF;
END;

[black_snail]

Is it possible ? I saw you grant create trigger priviledge to the user BBB ?

[mary31]

是啊 但是为什么没有创建触发器权限呢。。？

[black_snail]

Are you sure you grant the create trigger priviledge and
connect as bbb

I tried the same , no problem

[mary31]

请各位用上边代码试一下，谢谢 我是一直不成功的 也赋予了grant the create trigger 权限

[luyuen]

我试过了，触发器名有问题，将“ "bbb".活动_ID ”改一下，我用“活动_ID”就通过。