This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I wish to know the difference between schema & user. What I know is, if a user is created, the schema -where in all the database objects are stored - is automatically created. My actual question is can a user be able to create multiple schemas? I know he can be given respective privileges to access other user' s schemas.
I feel answer for this question varies with different DBMS's. So please mention the DBMS which you are referring to, along with SQL statements
Barring the case of enterprise users, where users are defined outside the database and then multiple users can be assigned to a particular schema, the relationship between users and schemas is 1:1. A schema is the set of objects owned by a database user. A single database user, by definition, cannot own objects in different schemas.