Insufficient privileges to create sequence with DBA role?

  • From: Michael Ray <topshot.rhit@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 19 Jun 2006 12:32:29 -0400

Why would I get ora-01031 on "create sequence pump_id_seq minvalue 10000 nocache;" as the schema owner, which I verified has the DBA role and (implicit?) create any sequence system privilege? I also tried with the schema name specified.

10gR2 on Win 2003

--

Sincerely,
Michael Ray
Topshot Systems LLC
--
//www.freelists.org/webpage/oracle-l


Other related posts: