Unable to get session information from Database dashboard. When navigating to Database | Overview | Activity and see following error:
An error occurred while trying to retrieve data to this screen.
Error captured in Foglight Management Server (FMS) log:
The foglight user does not have the privilege to query the column from V$SESSION.
System tables like V$SESSION, V$SQLAREA, V$INSTANCE need a special privileges like SYSDBA to access.
Validating Connectivity steps provide an option to to specify a SYSDBA (user with sufficient privileges) so that it can grant the privileges.
1. Execute the commands using user foglight with a SYSDBA user and compare result output.
SELECT * FROM V$SESSION
2. Check if Oracle VPD (Virtual Private Database) is used for access control policy. If yes, contact your database administrator.