IPM provides powerful abilities to view information about any user session and the Ingres installation as a whole. It requires restricted system privileges to run.

You can install IPM so that less privileged users can use it. However, this type of installation permits any user to display large quantities of system and other user information. Users can display, for example, what other user sessions are running, what tables other users are accessing, whether a given user session is currently active, how much log file space any transaction is taking up, which user sessions are holding locks blocking which other sessions, and so on.

Privileges are required to view queries or remove sessions or servers.

UNIX: By default, IPM can be run only by the Ingres system administrator. This is the account used for performing installations.

If needed, you can permit IPM to be run by less privileged users with the following command entered at the operating system prompt:

VMS: By default, IPM can be run only with operating system privileges that requires SYSPRV CMKRNL and WORLD privileges.

If needed, you can permit IPM to be run by less privileged users by installing it with enhanced privileges. To do this, type the following at the operating system prompt: