Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> insufficient privileges on create trigger ?

insufficient privileges on create trigger ?

From: <mikelarry88_at_yahoo.com>
Date: 17 Jul 2005 06:48:38 -0700
Message-ID: <1121608118.359753.132690@f14g2000cwb.googlegroups.com>


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

                 *

ERROR at line 2:
ORA-01031: insufficient privileges

Thanks much., Received on Sun Jul 17 2005 - 08:48:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US