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: ORA-01031: insufficient privileges

Re: ORA-01031: insufficient privileges

From: Sashi <smalladi_at_gmail.com>
Date: Mon, 27 Aug 2007 12:58:59 -0700
Message-ID: <1188244739.499999.166080@y42g2000hsy.googlegroups.com>


On Aug 27, 3:53 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Aug 27, 2:44 pm, Sashi <small..._at_gmail.com> wrote:
>
>
>
> > Hi all, I'm trying to create a new sequence thus:
> > ======================================================
> > SQL> CREATE SEQUENCE DEVICE_KEY.NextVal
> > 2 START WITH 1
> > INCREMENT BY 1
> > NOCACHE
> > NOCYCLE;
> > 3 4 5 CREATE SEQUENCE DEVICE_KEY.NextVal
> > *
> > ======================================================
> > And it throws up an error:
> > ======================================================
> > ERROR at line 1:
> > ORA-01031: insufficient privileges
> > ======================================================
>
> > I'm trying to create the sequence withing my own schema. Then I tried
> > to grant access to myself
>
> > ======================================================
> > SQL> grant dba to ned;
>
> > Grant succeeded.
>
> > SQL> grant CREATE SEQUENCE to ned;
>
> > Grant succeeded.
>
> > ======================================================
>
> > Still the same error.
>
> > Can someone please explain what I'm missing and how to correct it?
>
> > Thanks,
> > Sashi
>
> Use the proper syntax, to begin with:
>
> CREATE SEQUENCE DEVICE_KEY
> START WITH 1
> INCREMENT BY 1
> NOCACHE
> NOCYCLE;
>
> Nextval is NOT proper for a CREATE SEQUENCE command.
>
> David Fitzjarrell

D'uh!!!!
Thanks, David. Received on Mon Aug 27 2007 - 14:58:59 CDT

Original text of this message

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