Java Mailing List Archive

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

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

Re: Insufficient privileges to create sequence with DBA role?

Michael Ray

2006-06-20

Replies:

Niall Litchfield wrote:
> obvious first comment
>
> you'd see this if you were issuing the statement in PL/SQL rather than
> in sqlplus.

I've seen that before (indeed all I found when researching dealt with
the execute immediate command) but this was a normal "create sequence"
command in SQL*Plus. I logged in as my user (with sysdba role also)
rather than schema owner and it worked so that was good enough for me.

--

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


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