Re: ORA-01031: insufficient privileges

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 Received on Mon Aug 27 2007 - 14:53:17 CDT