TABLE OF CONTENTS VIEWs, derived tables, materialized tables and temporary tables are ways of putting a query into a named schema object. By that, I mean they hold the query, rather than the results of the query.
A VIEW is also called a virtual table, to distinguish it from temporary and base tables. The definition of a VIEW requires that it act as if an actual physical table is created when its name is invoked. Whether or not the database system actually materializes the results or uses other mechanisms to get the same effect is implementation-defined. The definition of a VIEW is kept in the schema tables to be invoked by name wherever a table could be used. If the VIEW is updatable, then additional rules apply.
The SQL Standard separates administrative (DBA) privileges from user privileges. Table creation is administrative and query execution is a user privilege, so users cannot create their own VIEWs or TEMPORARY TABLEs without having Administrative privileges granted to them.
In the Standard SQL model, a temporary table acts very much like a base table. It is persistent in the schema, but it "cleans itself up" automatically so users do not have to bother, and it can be shared among several users. The temporary table has the same user privileges model as a base table.
However, a user can build a derived table inside a query.
