The following rules describe how the setting for a database option in a group affects the setting for the same database option in a user who is a member of the group.
When you create a new group, Z and I Emulator for Web creates for the group a database option profile that contains the initial settings for all the database options.
When you create a new user, you must add the user to at least one group. When you create a new user as a member of one group, the user inherits the current settings for the database options in that group. That is, Z and I Emulator for Web sets the database options in the new user's profile to the same values as are currently set in the profile of the group to which the new user is added. For example, if you create User2 as a member of GroupA, and GroupA has the database option Show all table types on the Tables tab selected, then Z and I Emulator for Web selects this same option in User2's database option profile.
Thus, before you create users, it is a good idea to create and configure a default group that contains the settings for database options that you want the majority your users to have. Then, when you create a user, you can add the user to that default group. The user's profile then contains the same database options as the group.
When you modify a database option setting for a group that already contains users, then Z and I Emulator for Web changes the corresponding database option setting to the same value in all the database option profiles of all the users belonging to the group. (But see the next two rules for exceptions to this rule.)
|Z and I Emulator for Web does not make this change until you click OK in the Database On-Demand Group Options window.|
This rule states an exception to Rule 3. (The Table of database options below indicates the database options to which this rule applies.) When you modify the setting of a database option for a particular user in the Database On-Demand User Options window, Z and I Emulator for Web protects that particular option from inheriting or from being modified by a group setting. Here is an example scenario:
Moreover, a database option that you modify in a user profile is protected from any further modification by any group. To continue with the example scenario above, suppose that now:
This user override protection remains in effect for the life of the user profile. That is, when you modify a database option setting for a user, that option remains protected from inheriting or being modified by a group setting, no matter what you subsequently do with that user profile (such as remove it from GroupA, add it to GroupB, and so on).
This rule states another exception to Rule 3. (The Table of database options below indicates the database options to which this rule applies.) If a user belongs to two or more groups, and the groups have different settings for a particular database option, and you change the setting in one of the groups, and the setting is not protected by Rule 4, then Z and I Emulator for Web modifies the user profile to contain the more permissive of the settings among the groups for that database option.
In plainer language, if a user belongs to two or more groups, and you modify a particular setting in one of the groups, so that one or more groups have the option selected, while one or more other groups have the very same option not selected, and the option is not protected by Rule 4, then Z and I Emulator for Web selects the option in the user profile.
For example, suppose that User1 belongs to GroupA and GroupB, and that the database option Show all tables types on the Tables tab is:
Now suppose if you will that you unselect the option in GroupA. Z and I Emulator for Web:
The table below shows which database options are subject to Rules 4 and 5. If an option is not listed, then it is not subject to either Rule 4 or Rule 5.
|Database option:||Subject to Rule 4 (User override):||Subject to Rule 5 (More permissive):|
|Allow creating new SQL/File Upload statements||No||Yes|
|Allow saving SQL/File Upload statements||No||Yes|
|Allow deleting of SQL/File Upload statements||No||Yes|
|Allow manual editing of SQL statements||Yes||Yes|
|SQL query timeout||Yes||Yes (longest wait)|
|Allow SQL statements: Select||No||Yes|
|Allow SQL statements: Select Unique||No||Yes|
|Allow SQL statements: Insert||No||Yes|
|Allow SQL statements: Delete||No||Yes|
|Allow SQL statements: Update||No||Yes|
|Allow File Upload statements: Create||No||Yes|
|Allow File Upload statements: Replace||No||Yes|
|Allow File Upload statements: Append||No||Yes|
|Allow File Upload statements: Update||No||Yes|
|Show all table types||Yes||Yes|
|Show System table||Yes||Yes|
|Show Global temporary||Yes||Yes|
|Show Local temporary||Yes||Yes|
|Allow user to configure Database On-Demand options||No||Yes|
|Allow user to configure general options||No||Yes|
|Allow user to configure tables options||No||Yes|
|Allow user to register JDBC drivers||No||Yes|
|Allow user to configure default logon properties||No||Yes|
|Allow user to configure BiDi options||No||Yes|