User-extended Role Options window

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

This window has the following components:

User-extended role Shows the name of the selected user-extended role.
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 default values based on the type of options selected in the Show list.
Value Choose an option in the Options list, and then type or select 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 user-defined role unless there is already a PUBLIC role setting for that option.

Once you select an option, you can use the buttons at the side of the window.

New This button is only enabled when you are setting options for the PUBLIC role. You must open the Options window for the PUBLIC role to add new options.
Remove Now This button is enabled for the PUBLIC role when an option is selected. This button is enabled for non-PUBLIC roles and users only when there is a value in the Settings column.
Set Permanent Now To change a setting for a user-extended role permanently, select an option, type the setting in the Value field, and then click Set Permanent Now.