Viewing or Modifying Role-Based User-Extended Role Options

View or change database option settings assigned to a user.

Prerequisites

Database Version	Role-Based User-Extended Role Privileges
SAP Sybase IQ 15.3 and 15.4	Not Supported.
SAP Sybase IQ 16.0	View user-extended role options only – none. Modify user-extended role options – Depending on the option being modified, you must have one of: SET ANY PUBLIC OPTION system privilege SET ANY SECURITY OPTION system privilege SET ANY SYSTEM OPTION system privilege

The SAP Sybase IQ resource is authenticated and running.
The selected resource supports role-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 16.x documentation, see the alphabetical list of Database options in IQ-product-name Reference: Building Blocks, Tables, and Procedures.

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Security > Role-Based, and then select User-Extended Roles.
Select a user-extended role 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.
Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.