SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to dialog boxes
The User Options dialog has the following components:
User Displays the name of the selected 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. Once you select an option, you can use the buttons at the side of the dialog.
New This button is not enabled when you are setting user options. You must open the Database Options dialog to add new options.
Remove Now This button is not enabled when you are setting user options. You must open the Database Options dialog to remove options.
Set Temporary Now To temporarily change an option setting for a user, select an option from the Options list, type the desired setting in the Value field, then click Set Temporary Now.
Temporary values only last for the current Sybase Central session.
Set Permanent Now To permanently change a setting for a user, select an option from the Options list, type the desired setting in the Value field, then click Set Temporary Now.
Permanent values last between sessions until they are explicitly changed again.
Value Select an option in the Options list and type the desired setting in the Value field. You can make the setting temporary or permanent by clicking Set Temporary Now and Set Permanent Now respectively. An option value cannot be set for an individual user ID unless there is already a PUBLIC group setting for that option.
When you change options settings, some of the settings take effect immediately, while for others to take effect you must restart the database.
For information about specific options, see Alphabetical list of options.
Managing User IDs and Permissions