I'm trying to understand the concepts of the schema, user and database.
My current understanding is you cannot create a schema separately. You can create a user and a schema will be automatically created.
Then my question is, what if you want to create 3 users and only use one schema by granting privileges to only one schema? Will there be 2 empty, unused schemata?
For example, in a project called "Killer Web", I have 3 application developers and I am the DBA.
So I created 3 users for each developer, dev1, dev2 and dev3. And I granted on these three devs, access and other privileges to the actual schema on which the 3 devs will actually work. Would that create 3 schemata, empty and unused?
If I wanted to create a schema called "KillerWeb", would I have had to create a "user" called "KillerWeb"?
How do I host multiple projects on one Oracle database and separate them?
In MySQL, I would just create a database for each project. (Not sure if this is the correct practice though.)