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

• Set properties for database objects
• Database options