Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: Insufficient privileges to create sequence with DBA role?

Stefan Knecht

2006-06-20

Replies:

Michael,

alter session set events '10046 trace name context forever, level 12';

<run your create statement>

alter session set events '10046 trace name context off';

check user_dump_dest for a resulting tracefile and check where exaclty an ERROR line is reported.

that will help you to track down the issue.


Stefan

On 6/19/06, Michael Ray <topshot.rhit@gmail.com > wrote:
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



©2008 dba.5341.com - Jax Systems, LLC, U.S.A.