Granting permissions on system tables to control access

If your DBMS supports SQL GRANT and REVOKE statements, you can control access to the DataWindow Designer system tables. The default authorization for each repository table is:

GRANT SELECT, UPDATE, INSERT, DELETE ON table TO PUBLIC

After the system tables are created, you can (for example) control access to them by granting SELECT authority to end users and SELECT, UPDATE, INSERT, and DELETE authority to developers. This technique offers security and flexibility that is enforced by the DBMS itself.