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: Francesco <fmarchioniNIENTESPAM_at_libero.it>
Date: Mon, 04 Aug 2003 07:25:13 GMT
Message-ID: <tTnXa.224329$lK4.6678086@twister1.libero.it>


Hi, thanks for your answers. I'll treasure your hints. bye!
Francesco

"Tanel Poder" <tanel@@peldik.com> ha scritto nel messaggio news:3f2d0686$1_1_at_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 Mon Aug 04 2003 - 02:25:13 CDT

Original text of this message

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