user13356913 wrote:Please stay away from pre-defined roles (should be documented in Security guide, I believe).
Thanks for your prompt response, following which I've been reading-up on Schemas and Roles, and started
experimenting with Oracle Database 10g Express Edition. I created a new user, 'TestUser', with Connect,
Resource, Create Table and Create View privelages, and can open and close the connection okay. However,
This should have created a schema called 'PseudoDB' associated with TestUser,No. That's another difference in concept and implementation. Oracle does not implement user - schema realtionship the same way as MS SqlServer (aka user-schema separation). Username = schema name.