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...


> 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