Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> insufficient privileges on create trigger ?
why does my SQLPlus complain that I dont have privileges ? Table C is
created by me. What am I doing wrong here ?
SQL> run ;
1 CREATE TRIGGER C_TRIG
2 BEFORE INSERT ON C
3 FOR EACH ROW
4 BEGIN
5 :NEW.val2 = :NEW.val2 + 10;
6* END C_TRIG;
BEFORE INSERT ON C
*
Thanks much., Received on Sun Jul 17 2005 - 08:48:38 CDT
![]() |
![]() |