Disabling the tree view, multirecord update, and SQL editor features for the web client

• For tree view, the master property is ALLOW_TREE_VIEW.
• For multirecord update, the master property is ALLOW_MULTIRECORD_UPDATE.
• For SQL editor, the master property is ALLOW_VIEW_SQL.
• For inline create, the master property is ALLOW_INLINE_CREATE.
• For inline editing, the master property is ALLOW_INLINE_EDIT.
• For tree view, the master property is ALLOW_TREE_VIEW.
• For multirecord update, the master property is ALLOW_MULTIRECORD_UPDATE.
• For SQL editor, the master property is ALLOW_VIEW_SQL.
• For form selection, the master property is ALLOW_FORM_SELECTION.
• For dynamic forms, the master property is ALLOW_DYNAMIC_FORMS.
• For view record reveal existence, the master property is VIEW_RECORD_REVEAL_EXISTENCE.
• For public templates, the master property is ALLOW_PUBLIC_TEMPLATES.
• For public list views, the master property is ALLOW_PUBLIC_LIST_VIEW_CONFIGS.

Use the installutil setmasterproperty subcommand to set the master property for the database set. The following are some examples for the tree view. You can disable the tree view feature for only the SAMPL database:

• installutil setmasterproperty dbset_name -user_db_name SAMPL cq_login cq_password ALLOW_TREE_VIEW

You can unset the property ALLOW_TREE_VIEW for the SAMPL database to re-enable the tree view feature:

installutil setmasterproperty dbset_name -user_db_name SAMPL cq_login cq_password ALLOW_TREE_VIEW “” o

• To disable the tree view feature for all databases, then enable it for two specific user databases through the following commands:

installutil setmasterproperty dbset_name cq_login cq_password ALLOW_TREE_VIEW 0

• To remove the setting for all databases, including two specific databases, do this:

installutil setmasterproperty dbset_name cq_login cq_password ALLOW_TREE_VIEW “”

1. Open Site Configuration.

2. Select the Application Options tab.

3. Specify the list of groups whose members that should be allowed to use the features in the Allow Tree View Groups, Allow MultiRecord Update Groups, or SQL Visible To Groups fields:

Note that there are similar group lists to restrict the Inline Create and Inline Edit features to certain groups. These restrictions have no effect if the corresponding feature is disabled by the corresponding master property.