Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Create table right
Answer embedded
-- Regards Michel Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> a écrit dans le message : 39b791d8.842005359_at_news.alt.net...Received on Thu Sep 07 2000 - 09:43:38 CDT
> On Thu, 7 Sep 2000 10:42:55 +0200, "Michel Cadot"
> <micadot_at_netcourrier.com> wrote:
> >> 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>;
>
> How do you decide which tablespace the table is created in? Which
> schema?
>
> Imagine I have
>
> 1) two users.
> a) User_1
> b) User_2.
>
> 2) two tablespaces
> a) TB_1
> b) TB_2.
>
> 3)
> a) User_1's default tablespace is TB_1
> b) User_2's default tablespace is TB_2.
>
> i) How does User_1 create a table in TB_2.
create table <tablename> (...) tablespace tb_2;
> ii) How does User_1 create a table in User_2's schema.
create table user_2.<tablename> ...
>
>
> Brian