Re: privileg question

From: Markus Innerebner <markusin_at_yahoo.de>
Date: Fri, 01 Oct 2004 09:36:21 +0200
Message-ID: <2s4forF1g2pb1U1@uni-berlin.de>

Hans Forbrich wrote:
> Markus Innerebner wrote:
>
>

>>Hello
>>
>>i want to know, if it is possible to login remote via a JDBC-connection
>>as SYSDBA.
>>It's important for me, because so I could create new databases.
>>
>>thanks for your answer.

>
>
> Are you trying to create a new database? Or a new Oracle schema?
>
> These are two different concepts - as far as I know, it is not possible to
> create a database using JDBC ... as the catalog and standard packages have
> not been created, there is not enough intelligence to interpret your JDBC
> request.
>
> If I understand your question - you might find some relevant discussion in
> the Oracle documents - 'Concepts Manual', 'Application Developer's
> Fundamentals' and 'Java Developers' - found at http://docs.oracle.com
>
> /Hans

Thanks for your information. I know the difference between a database and a schema. A schema would be created by creating a new user. My intuition is that via remote someone could be logged in as SYSDBA and can create a new database( setting SID, init<dbname>.ora, ...). On the other hand it's better that it isn't allowed, to do that.

regards Markus Received on Fri Oct 01 2004 - 02:36:21 CDT