Viewing or Modifying Authority-Based User Options

View or change database option settings assigned to a user.

Prerequisites

Database Version	Authority-Based User Permissions
SAP Sybase IQ 15.3 and 15.4	Requires DBA authority.
SAP Sybase IQ 16.0	Not supported.

The SAP Sybase IQ resource is authenticated and running.
In a multiplex configuration, the coordinator node is running.
The selected resource supports authority-based security.

Task

For database options that can be set at either level, when set at the user level, the setting overrides the current value for that user only. When set it at the database level, the value becomes the new default, and is applied to any existing users who have not had the option overridden at the user level.

For information on the level at each option can be set and the system privilege required, in the SAP Sybase IQ 15.x documentation, see the alphabetical list of Database options in SAP Sybase IQ Reference: Statements and Options.

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Security > Authority Based > Users.
Select a user from the right pane and either:
- Click the arrow to the right of the name and select Options, or
- From the Administration Console menu bar, select Resource > Options.
A list of the current settings of each option appears.
To change a setting, click in the Setting column for the option and enter the new value.
Choose one of the following:
- Click Apply to save the change and continue modifying options.
- Click OK to save all changes and close the Options view.