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:
Remote User Displays the name of the selected remote user.
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 an individual user ID 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 not enabled when you are setting remote user options. You must open the Database Options window to add new options. For instructions about how to open the Database Options window, see How to set database options using the SET OPTION statement.
Remove Now This button is not enabled when you are setting remote user options. You must open the Database Options window to remove options.
Set Permanent Now To change a setting for the remote user permanently, select an option from the Options list, type the setting in the Value field, then click Set Permanent Now.
Permanent values last between sessions until they are explicitly changed again.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|