Error: Cannot determine schema owner for Linked Server

Products

• Information Centric Analytics

Issue/Introduction

The following error is returned by the New Connection Wizard when adding a new Symantec Data Loss Prevention (DLP) data source:

Cannot determine schema owner for Linked Server = RISKFABRIC_DLP_RISKFABRIC_<hostname>_PROTECT

Environment

Release : 6.x

Component : Symantec Data Loss Prevention Integration Pack

Cause

This error occurs when the New Connection Wizard is unable to query the schema owner of the DLP database. This may be due to insufficient privileges held by the Oracle account entered in the New Connection Wizard, or by the presence in the Oracle instance of multiple database schemas containing a table named 'INCIDENT'.

Resolution

Ensure the Oracle account you enter in the Database Settings page of the New Connection Wizard has read access to all protect (DLP database) tables and the ALL_OBJECTS system table.

If multiple DLP database schemas exist in the same Oracle database instance, enter the target DLP Schema Owner on the API Settings page of the New Connection Wizard.

Additional Information

The following query executed in SQL*Plus or Oracle SQL Developer will return the owner(s) of all database schemas containing a table named 'INCIDENT' to which the user has access:

SELECT OWNER FROM ALL_OBJECTS WHERE OBJECT_NAME = N'INCIDENT';