ORA-01031: insufficient privileges

From: Sashi <smalladi_at_gmail.com>
Date: Mon, 27 Aug 2007 12:44:01 -0700
Message-ID: <1188243841.743554.131170@r34g2000hsd.googlegroups.com>

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