Re: oracle 9i connection string with SYS account

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 4 Jun 2002 16:32:34 +0200
Message-ID: <adij5d$6ik$1@crusher.de.colt.net>

> OK, but help me out here, I've created a user with DBA privileges. But
when
> I issue a "create database" statement I get an error stating I have
> insufficient privileges. How can I create a user who can create databases
> too?

I am pretty sure you should RTFineM before working w/ Oracle. This is not SQL Server. When you create a user there is already a database. What you are talking about is a schema. Refer to the documentation for further information.
Sorry, not to explain everything here, but I'd be too much to write and there are many better docs out there.

Regards,

Knut Received on Tue Jun 04 2002 - 09:32:34 CDT