Database Error logging into TDM DataMaker when using Oracle database for repository

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When we log into TDM DataMaker we are receiving an Oracle ORA error ORA-00942.
The oracle database is as 12.x database

Environment

TDM 4.9.X, 4.8.x
Datamaker 4.9.X, 4.8.x

Cause

Incorrect permissions on the oracle database for the user.

Resolution

The TDM repository user requires grant select on v$session.  
example

grant select on v$session to TDMUSER.