Why Oracle Connector requires the permission to v$session table?

Products

• CA Identity Suite
• CA Identity Manager

Issue/Introduction

From the document the Oracle connector requires the permission to the v$session table.

Create the Oracle Server Endpoint

To acquire the Oracle Server connector successfully, provide access to the v$session tables to the user that acquires the connector.

Environment

Identity Manager 14.x

Resolution

V$SESSION is a fundamental tool in Oracle Database for real-time monitoring, troubleshooting, and performance tuning. It provides comprehensive insights into active sessions, resource usage, locks, and session-related details, enabling administrators to manage and optimize database performance effectively

The Broadcom Identity Management Connector Server needs the permission to access to the v$session tables to the user that used to acquires the endpoint. IM uses this table mainly for session management related things, and will look for active sessions associated with the provided user in the table v$session which helps to manage the session.