Disconnecting Users and Terminating Requests in Essbase Native Security Mode

The security system lets you disconnect a user from the Essbase Server in order to perform maintenance tasks.

To view sessions, disconnect sessions, or terminate requests, you must have Administrator permission or Application Manager permission for the specified application. You can view or terminate only sessions or requests for users with permissions equal to or lesser than your own.

A session is the time between login and logout for a user connected to Essbase Server at the system, application, or database scope. A user can have multiple sessions open at any time; for example, a user may be logged on to different databases. If you have the appropriate permissions, you can log off sessions based on any criteria you choose; for example, an administrator can log off a user from all databases or from one database.

A request is a query sent to Essbase Server by a user or by another process; for example, a default calculation of a database, or a restructuring of the database outline. Each session can process only one request at a time.

Note:

You cannot terminate a restructure process. If you attempt to terminate it, a "command not accepted" error is returned, and the restructure process is not terminated.

  To disconnect a session or request using Administration Services, see “Disconnecting User Sessions and Requests” in the Oracle Essbase Administration Services Online Help.

  To disconnect a session or request using MaxL, use alter system kill request or alter system logout session. See the Oracle Essbase Technical Reference.

  To disconnect your own active request using MaxL Shell or ESSCMD, press the ESC key.

  To disconnect your own active request using a custom API program, set up a custom callback function. See the topic for ESS_INIT_T in theOracle Essbase API Reference.