ASA Database Administration Guide
  Managing User IDs and Permissions

Managing connected users

If you are working with Sybase Central, you can keep track of all users connected to the database. You can view properties of these connected users, and you can disconnect them if you want.

To display a list of all users connected to a database

1. In Sybase Central, connect to a database.

2. Click the database in the left pane, and click the Connected Users tab in the right pane.

   This tab displays all other users currently connected to a given database (including yourself), regardless of the client that they used to connect (Sybase Central, Interactive SQL, a custom client application, etc.).

To inspect the properties of a user's connection to a database

1. In Sybase Central, connect to a database.

2. Click the database in the left pane, and click the Connected Users tab in the right pane.

3. Right-click the desired user and choose Properties from the popup menu.

4. Inspect the desired properties.

To disconnect users from a database

1. In Sybase Central, connect to a database.

2. Click the database in the left pane, and click the Connected Users tab in the right pane.

3. Right-click the desired user and choose Disconnect from the popup menu.