Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Configuring Your Database » Managing user IDs, authorities, and permissions » Managing user permissions and authorities overview

 

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