Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database configuration » Database options

 

Changing database options (Sybase Central)

Change the values of database options for a database, user, or role.

Prerequisites

Any user can set their own options.

To set database options for other users or roles, including the PUBLIC role, you must have one of the following system privileges, depending upon which privilege the option requires:

  • SET ANY SYSTEM OPTION
  • SET ANY PUBLIC OPTION
  • SET ANY SECURITY OPTION
  • SET ANY USER DEFINED OPTION

Context and remarks

Changing the options for the database is equivalent to changing the options for the PUBLIC role.

Any option, whether user-defined or not, must have a PUBLIC setting before a user-specific value can be assigned. You can only create new options for the PUBLIC role.

Changing the value of an option for the PUBLIC role changes the value of the option for all users, except those who have explicitly set values for that option. When you set the value of an option for a user or role (other than the PUBLIC role), the new value overrides the value set by the PUBLIC role.

When you remove an option from a user or role, the PUBLIC setting for the option is applied. When you remove an option from the PUBLIC role, the option is removed from the database. All user settings for options must be removed before the option can be removed from the PUBLIC role.

You cannot set or change temporary options using Sybase Central. To set a temporary option, use the SET OPTION statement.

 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Choose one of the following options:

    Option Action
    Change the options for the PUBLIC role

    1. In the left pane, click Roles.

    2. In the right pane, right-click PUBLIC and click Options.

    Change the options for a role

    1. In the left pane, click Roles.

    2. In the right pane, right-click the role and click Options.

    Change the options for a user

    1. In the left pane, click Users.

    2. In the right pane, right-click the user and click Options.

  3. Configure options for the user or role. The possible values you can specify appear in the Value field. Choose one of the following options:

    Option Action
    Add an option Click New and specify the option name and value.
    Alter an option Change the option value in the Value field, and then click Set Permanent Now.
    Remove an option Select the option and click Remove Now.

  4. Click Close.

Results

The values of database options for the database, user, or role are changed.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0