I don't think it's possible. You can restrict default temporary tablespace (only on Oracle 9i), but not default tablespace. You can use a trigger as a workaround (AFTER CREATE ON DATABASE) and change the default tablespace just after the user creation.
However, that workaround seems disgusting (at least for me). What do you think about changing the policy? Is it really necessary that application users have the right to create users on database?
Last edited by adrianomp; 03-20-2003 at 12:26 PM.
An ounce of action is worth a ton of theory.
—Friedrich Engels
