Setting Database Options

Adjust the configurable settings of a database to change the way the database behaves or performs.

Prerequisites

Database Version	Database Privileges
SAP Sybase IQ 15.3 and 15.4	View database options only – None required. Modify database options – Requires DBA authority.
SAP Sybase IQ 16.0	View database options only – None required. Modify database options – Depending on the option being modified, requires one of: SET ANY PUBLIC OPTION system privilege. SET ANY SECURITY OPTION system privilege. SET ANY SYSTEM OPTION system privilege.

Database Version

Database Privileges

SAP Sybase IQ 15.3 and 15.4

View database options only – None required.

Modify database options – Requires DBA authority.

SAP Sybase IQ 16.0

View database options only – None required.

Modify database options – Depending on the option being modified, requires 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.

Task

Some database options can only be set at one level, be it database (PUBLIC) or user, while others can be set at either level.

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 > Schema Objects > Databases.
Select a database from the right pane and either:
- Click the drop-down arrow to the right of the name and select Options, or,
- From the Administration Console menu bar, select Resource > Options.
The Options for Database "X" view appears.
Click in the Setting column to modify an option value.
Click Apply to save your changes and keep editing, or click OK to save and close the Database Options view.