Disabling 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 created without the supervision of the system administrator. If required, you can make it so only an administrator level account can create views.
1. Click Security -> Allow "Create View" SQL Statements in the CONNX Data Dictionary Manager window.
This disables the feature - views cannot be created by anyone other than the system administrator.
2. Click the same menu item to enable it again.