dmw (8/12/2009)
So, if I want to 'create another schema' for a user, I must generate a pseudo user/schema and then grant access to my original user.
The beauty of it is that there is not such a thing as CREATE SCHEMA MySchema statement.
You create Oracle accounts a.k.a. users, then if you create an object "owned" by such Oracle account you get a schema with the same name.
I would think of it like your app will require two "kinds" of Oracle accounts.
Operational accounts, which own objects inside a schema.
User accounts, which own no objects but have access granted to objects in one or more -if needed, schemas.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.