Re: insufficient privileges on create trigger ?

On 17 Jul 2005 06:48:38 -0700, mikelarry88_at_yahoo.com wrote:

>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.,

You did verify you actually do have the CREATE TRIGGER privilege?

--
Sybrand Bakker, Senior Oracle DBA