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 required. Modify user-extended role options – Depending on the option being modified, requires one of these: 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 SAP Sybase IQ Reference: Building Blocks, Tables, and Procedures.

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Security > Role-Based > 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.
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.