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

book

Article ID: 206802

calendar_today

Updated On:

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

Below is the error we are seeing

 

Cause

Incorrect permissions on the oracle database for the user.

Environment

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

Resolution

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

grant select on v$session to TDMUSER.