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

The TS will default to SYSTEM.

You can change the default and temporary TS of a user using ALTER USER username [DEFAULT TEMPORARY] TABLESPACE TS

---
------------------------------------------------------------------------------
David Crowson   =%^)   |"For my part, I travel not to go anywhere, but to go. 
Oracle DBA(Ver.4,5,6,7)| I travel for travel's sake. The great affair is to
Amoco Exploration      | move, to get down off this featherbed of civilisation
Ealing, London         | and to find the globe granite underneath and strewn
"My views not Amoex's" | with cutting flints" : Robert Louis Stevenson