Re: create database

On 27 Apr 2001, you wrote in comp.databases.oracle.misc:

>Thomas Vatter wrote:
>
>> When I try sql "create database" with jdbc there is the error "01031
>> unsufficient priviliges". I have connect before to an existing
>> database with the ora thin driver. I tried with the accounts
>> "system", "sys" and "internal".
>> I have Oracle running on NT and there is a user group "ora_dba". The
>> client logs in as "system" or "sys". Do I have to create a user
>> "system" or "sys" on NT and put them in the group "ora_dba"?
>
>I've never tried it but I sincerely hope it is absolutely impossible to
>do what you are trying to do.
>
>To run the create database command you need the following. You need to
>be in either server manager or SQL*Plus (most recent version only). You
>need to have an init.ora file. If you are on Windows NT you must have
>already created the Oracle services using oradim.exe. And you must
>either be logged on as sys (internal) or with equivalent privileges.
>
>The group ora_dba, is irrelevant to the process. I've probably built
>50-60 Oracle servers on NT and never had any need to create that group.
>
>My advice to you would be to forget Java until you know how to do it
>manually. And as I said above, I sincerely hope that what you are trying
>to do is impossible.
>
>Daniel A. Morgan
>
>

thanks a lot for your answer! I had checked the online manuals, for "create database" but couldnt find this info. So I wont create the database remotely. But I wonder if it is the right way if network applikations cant create the database to save their data. Thus installation will be more complicated and customers dont like that. Sure dbas want to keep their job, but perhaps today this is not creating databases but administrating, configuring, tuning etc. Am I wrong? Received on Fri Apr 27 2001 - 05:12:39 CDT