Creates a view of data from one or more tables or other views.
| Category: | Data Definition |
| Data source: | SAS data set, SPD Server table, Aster, DB2 under UNIX and PC, Greenplum, HAWQ, HDMD, Hive, Impala, MDS, MySQL, Netezza, ODBC, Oracle, PostgreSQL, SAP HANA, Teradata |
specifies the type of security that will be enforced for the view. security-type can be one of the following values.
specifies that the view is run with the schema owner’s credentials.
specifies that the view is run with the invoking user’s credentials.
| Default | If SECURITY is not used, security for the view defaults to INVOKER. |
| Restriction | Security is available only with SAS Federation Server. The SECURITY security-type argument is ignored in a FedSQL request that is not directed to SAS Federation Server. For more information about the security available through SAS Federation Server, see the documentation for SAS Federation Server. |
specifies the name of the view being created.
| Requirement | The view name must be different from any other view, table, or index in the same database. |
specifies the SELECT statement that retrieves the information from an existing table that is used to create the view.
| See | Creating and Populating Tables from a Query Expression, Query Expressions and Subqueries, and SELECT Statement |