From: fvanbortel@netscape.net   
      
   tracy wrote:   
   > hi, x   
   > dev_user only have priviledge to create table under his own tablespace   
   > which is dev_user only. he only granted the priviledge 'create table'   
   > not 'create any table'   
   >   
   >   
   > "x"  wrote in message news:...   
   >   
   >>>I wonder, how can the table   
   >>>created by them is in system schema? Pls let me know, if u have the   
   >>>answer.   
   >>>   
   >>   
   >>create table my_table (x varchar2(1)) tablespace system   
   >>   
   >>Easy as that. If your dev_user has right priviledges he can create table   
   >>where ever he wants.   
      
   Unless granted the resource role, which offers quota unlimited on   
   any tablespace. Unless you specifically do   
   alter user quota 0 on system;   
   your dev_user can still create objects in the system tablespace   
   --   
      
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)