Setting user and group options

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.

 To set options for a user or group (Sybase Central)

  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 choose Options.

  4. In the Options list, click an option.

  5. Click Set Permanent Now.

  6. Click Close.

 To set the options for a user or group (SQL)

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

  2. Execute a SET OPTION statement.

 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0