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

Home -> Community -> Usenet -> c.d.o.misc -> Re: create db insufficient privileges

Re: create db insufficient privileges

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 28 Oct 2003 13:47:06 -0800
Message-ID: <1067377643.804476@yasure>


mercurio wrote:

>Hello,
>I connect as System Manager to create a database but I get " Insufficient
>Privileges"
> "create database mydb
> controlfile REUSE
> maxlogfiles 5
> maxinstances 2
> archivelog
> character set US7ASCII;"
>
>which privileges should have the user "System" ?
>
>
>
>TIA
>
>

Can't, and shouldn't, be done by SYSTEM. Definitely should not be done with the SQL you
included above. I'd suggest you go to tahiti.oracle.com and read up on the subject.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Oct 28 2003 - 15:47:06 CST

Original text of this message

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