400: A table with the specified name does not exist

Products

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

Issue/Introduction

While trying to add seed list connection for database, I am getting below error in TDM portal.

"Failed to save DB Seedlist configuration

400: A table with the specified name does not exist for this connection profile"

The table "gtsrc_reference_data" does exist in database "Scramble" and I am able query also.

Environment

Release : 4.10

Cause

Insufficient access for the user being used in connection profile.

Resolution

Granting required permissions to the DB user configured in the connection profile resolved the issue.