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 -> Re: insufficient privileges on create trigger ?

Re: insufficient privileges on create trigger ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 17 Jul 2005 18:37:21 +0200
Message-ID: <i82ld1hcp6de62bd3210r5lvt5hgtif14u@4ax.com>


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
Received on Sun Jul 17 2005 - 11:37:21 CDT

Original text of this message

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