Re: Insufficient privileges to create sequence with DBA role?

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_at_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
>
>
>

--
http://www.freelists.org/webpage/oracle-l