To be able to create views in a user's own schema, the user needs to have
the CREATE VIEW privilege, or the CREATE ANY VIEW privilege, which is more powerful,
and allows the user to create views in other user's schema.
The following tutorial exercise gives you
a good example on CREATE VIEW privilege: