Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Insufficient privileges to create sequence with DBA role?
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-lReceived on Tue Jun 20 2006 - 05:49:59 CDT
![]() |
![]() |