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.