Controlling access to QMF and database objects

QMF objects, such as queries and procedures, and functions such as the Table Editor, allow users to access and manipulate data stored in tables in the database. Because this data might be sensitive, you may need to control users' access to certain objects:

• You can use SQL GRANT and REVOKE statements from QMF's SQL query panel to control access to tables and views, as discussed in Granting and revoking SQL privileges. SQL privileges required to access objects explains privileges required to use specific QMF commands or functions on objects.
• You can use the SHARE parameter of the QMF SAVE command to control access to queries, forms, and procedures, as discussed in Sharing QMF objects with other users.