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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Create table right

Re: Create table right

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 7 Sep 2000 10:42:55 +0200
Message-ID: <8p7kh0$i08$1@s1.read.news.oleane.net>

Answer embedded.

--
Have a nice day
Michel


Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> a écrit dans le message :
39b6a007.780100015_at_news.alt.net...

> What is the difference between "Create Table" and "Create Any Table"?
>
"Create table" gives you the right to create a table in *your* schema. "Create any table" gives you the right to create a table in *any* schema.
> Also, how do I grant a user to right to create table in a specific
> tablespace?
Once you give him the "create table" privilege, you have to give him a quota not a right on this tablespace: alter user <the user> quota xxxK on <the tablespace>; alter user <the user> quota unlimited on <the tablespace>;
>
> Brian
Received on Thu Sep 07 2000 - 03:42:55 CDT

Original text of this message

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