Managing connected users

You can keep track of all users connected to the database by using Sybase Central. You can view properties of these connected users and you can disconnect them.

Prerequisites

You must have the DROP CONNECTION, MONITOR, or SERVER OPERATOR system privilege.

Context and remarks

You can also view a list of all users connected to a database from the Connections widget in the SQL Anywhere Monitor.

Task

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
Display a list of all users connected to the database.
1. Select the database in the left pane, and click the Connections tab in the right pane.
  
  This tab displays all users currently connected to the database, regardless of the application that they used to connect (Sybase Central, Interactive SQL, or a custom client application).
Inspect the properties of a user's connection to a database.
1. On the Connections tab, right-click the user and then click Properties.
2. Review the properties for the user and click OK.

Results

The properties of the connected users are reviewed.

Next

You can disconnect a user from the database.

Managing connected users

Task

See also