You need the Oracle Rdb READ and DEFINE privileges to the referenced
    relations to use the DEFINE VIEW statement.

    When the DEFINE VIEW statement executes, Oracle Rdb adds the view
    definition to the physical database. If you have invoked the
    database with the PATHNAME argument, the definition is also
    stored in the data dictionary.

    You must execute this statement in a read/write transaction. If
    you issue this statement when there is no active transaction,
    Oracle Rdb starts a read/write transaction implicitly.

    Other users are allowed to be attached to the database when you
    issue the DEFINE VIEW statement.