User – Schema relation

We know that database objects are contained in Schema and schema are owned by Database Principals. But this is not all about this user-schema relation.

Let us understand this relation with below drawing.



This drawing demonstrates following 5 facts:

1. A user can own multiple schemas.

2. A schema can be owned by a single users.

3. A user can have a single default schema.

4. A user may not own any schema but must have one default schema.

5. A schema could be default for many users.