To disable the creation of views

View-creation capability is automatically enabled in CONNX and can be performed with the SQL statement CREATE VIEW. This capability can be a security risk if views are being created without the supervision of the system administrator. View creation, however, can be disabled, limiting the ability to administrator use only.

 

To disable the creation of views

  1. Select Allow "Create View" SQL Statements on the Security menu in the CONNX Data Dictionary Manager window.

    image\UserRef_87.jpg
     

  2. The feature is disabled and views cannot be created by anyone other than the system administrator.