Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01031: insufficient privileges
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