When you change options, some of the settings take effect immediately, while for others you must restart the database before they take effect.

This window has the following components:

Group   Displays the name of the selected group.

Show   Provides a list of option types. For example, if you choose Database Options, only database-related options appear in the Options list.

Options list   Shows the option settings and their default values based on the type of options selected in the Show list. Once you select an option, you can use the buttons at the side of the window.

New   This button is not enabled when you are setting group options. You must open the Database Options window to add new options to the Options list. For instructions about how to open the Database Options window, see Setting database options.

Remove Now   This button is not enabled when you are setting group options. You must open the Database Options window to remove options from the Options list. For instructions about how to open the Database Options window, see Setting database options.

Set Permanent Now   To change an option setting for a group permanently, select an option from the Options list, type the setting in the Value field, then click Set Permanent Now.

Value   Select an option in the Options list and type the setting in the Value field. You can make the setting permanent by clicking Set Permanent Now. An option value cannot be set for a group unless there is already a PUBLIC group setting for that option. See Alphabetical list of options.

See also

• SET OPTION statement
• Managing user IDs, authorities, and permissions