Re: New user creation

In article <2kgj2nINN4k0_at_turtle.cis.ohio-state.edu>, skiba_at_cis.ohio-state.edu (david j skiba) writes:
> If I have a user with DBA access and that user creates a new user
> what are the new user's default tablespace and temp tablespace?
> Are they the same as the DBA who created the new user???
>
> dave skiba
>
>
SYSTEM is the default for both default tablespace and for temp tablespace, regardless of who creates the user.

Making SYSTEM the default tablespace doesn't hurt, because the user still has to be give RESOURCE (ORACLE6) or QUOTA (ORACLE7) on a tablespace to be able to create objects in that tablespace. Not that I'd ever recommend leaving a user's default tablespace as SYSTEM. We typically create a USERS_T01 tablespace and have all of our users default to that tablespace.

Leaving the users temporary tablespace as SYSTEM is bad news. ORACLE creates temporary segments in that tablespace on behalf of the user regardless of whether or not they have quota on the tablespace. You DO NOT want users creating temporary segments in the SYSTEM tablespace. We create a TOOLS_T01 tablespace and have all users' temporary tablespace set to that.

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285