Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Create table right
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...Received on Thu Sep 07 2000 - 03:42:55 CDT
> 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
![]() |
![]() |