Re: which privilege to create a database?

From: Grégory Luguet <gregory.luguet-NOSPAM_at_bull.net>
Date: Thu, 12 Dec 2002 16:24:48 +0100
Message-ID: <ata82i$8vk3@tosca.frcl.bull.fr>

> > 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 - 09:24:48 CST