Setting user and group options

 Set options for a user or group (Sybase Central)

In Sybase Central, configurable options for users and groups are located in the User Options and Group Options windows (the same window as for setting database options). In Interactive SQL, you can specify an option in a SET OPTION statement.

  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

  2. Click Users & Groups.

  3. Right-click a user or group and then click Options.

  4. In the Options list, click an option.

  5. Click Set Permanent Now.

  6. Click Close.

 Set the options for a user or group (SQL)

In Sybase Central, configurable options for users and groups are located in the User Options and Group Options windows (the same window as for setting database options). In Interactive SQL, you can specify an option in a SET OPTION statement.

  1. Connect to the database as a user with DBA authority.

  2. Execute a SET OPTION statement.

    For example, to set the date format option for all users that are in the PUBLIC group, execute the following statement:

    SET OPTION PUBLIC.date_format = 'Mmm dd yyyy';
 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1