Re: which privilege to create a database?

For that purpose you can create a user ( which also creates a schema to hold that user's objects) and restrict that user's privs to that schema - the user then can drop, create, insert, etc without accessing anyone else's stuff..Note, however, that a bad user ( meaning one who is not sufficiently versed in Oracle) can cause problems for the entire instance and or the server itself at that will affect the other users' ability to use their data.

hth

"Grégory Luguet" <gregory.luguet-NOSPAM_at_bull.net> wrote:

>> > Hello,
>> > I must create a database for a 3-tiers application and I wish I can do
>it
>> > with the user I specially created for.
>> > The problem is that there is no "grant create database" available, so
>how
>> > can I do it?
>> >
>> > The idea to create it with the system user and give all privileges on it
>to
>> > my user is quite unpleasant to me, any other way?
>>
>> Are you using the word database in the Oracle context or the SQL Server
>> context? Database or Schema?
>
>Actually I have a MySQL/Postgresql background
>
>> But in either case you can not unless your DBA grants you the privilege.
>And if
>> the DBA does they are crazy. Because anyone that would ask the question
>you
>> have asked should not be granted those privileges.
>
>Oh, dear!
>What I wanted was to have the possibility for a special account to have its
>own database (so to be able to create, drop or whatever with tables without
>pollute the other user's tablespace)
>
>> Go to http://tahiti.oracle.com and search on "CREATE DATABASE' and "CREATE
>> USER".
>
>OK, I am on my way
>
>> Daniel Morgan
>>
>
Received on Thu Dec 12 2002 - 11:44:54 CST