Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Insufficient privileges to create sequence with DBA role?

Insufficient privileges to create sequence with DBA role?

From: Michael Ray <topshot.rhit_at_gmail.com>
Date: Mon, 19 Jun 2006 12:32:29 -0400
Message-id: <4496D19D.80108@gmail.com>


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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 19 2006 - 11:32:29 CDT

Original text of this message

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