Prerequisites
To create a view in your own schema, you must have the
CREATE VIEW system privilege. To create a view in another user's schema, you must have the CREATE ANY VIEW system privilege.To create a subview, you must have the
UNDER ANY VIEW system privilege or the UNDER object privilege on the superview.The owner of the schema containing the view must have the privileges necessary to either select, insert, update, or delete rows from all the tables or views on which the view is based. The owner must be granted these privileges directly, rather than through a role.