A schema is a collection of all database objects under a user and the name same as this user. For example: \"select * from scott.emp\\\" The scott is schema not user.