SQL Statements › CREATE VIEW › Privileges

Privileges

If the Multi-User Facility is secured, whether the creator of the view may access that view depends on the security model of the view. Under the SQL Security Model, when a view is created the user who executes the CREATE VIEW statement is automatically granted all privileges on the view. Under the CA Datacom/DB External Security Model, all access rights, including those for the creator of a view, must be defined through the external security product. See the CA Datacom Security Reference Guide for more information.

With regard to table partitioning, CREATE statements may not be issued against a table which is partitioned nor against a partition. For more information about table partitioning, see the CA Datacom/DB Database and System Administration Guide.

Following is the syntax diagram for the CREATE VIEW statement:

►►─ CREATE ─┬───────────┬─ VIEWview-name ─┬───────────────────────────┬─ AS ──►
            └─ DATACOM ─┘                 │     ┌─ , ───────────┐     │
                                          └─ ( ─▼─ column-name ─┴─ ) ─┘

 ►─ subselect ─┬─────────────────────┬────────────────────────────────────────►◄
               └─ WITH CHECK OPTION ─┘