Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: create table privilege to a user

Re: create table privilege to a user

From: Tanel Poder <tanel_at_@peldik.com>
Date: Sun, 3 Aug 2003 15:56:37 +0300
Message-ID: <3f2d0686$1_1@news.estpak.ee>


Hi!

There's also a privilege called "unlimited tablespace" in Oracle, you can grant this one in development environment. In production it's not good practice, though, especially when users can directly login to database to create their objects...

Tanel.

"Francesco" <fmarchioniNIENTESPAM_at_libero.it> wrote in message news:NeoWa.218765$lK4.6397877_at_twister1.libero.it...
> Hi all,
> I have created a new tablespace and assigned it to a user as default
> tablespace. I can see that I cannot create tables on that tablespace
> unless a quota is assigned on the tablespace when I created the user.
> As I don't know how much quota do I have to assign a user, can I simply
> grant a privilege, instead ?
> Thanks a lot
> Francesco
>
>
>
Received on Sun Aug 03 2003 - 07:56:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US