Cannot Configure Shared Service-Error: "INSERT Permission Denied on Object 'HSS_COMPONENT_TYPES', Database 'HSS', schema 'dbo'." (Doc ID 1259716.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.2.1.000 and later
Information in this document applies to any platform.

Symptoms

When attempting to configure Shared Services the following error is returned in the ConfigTool_Summary.log file

=======================
java.sql.SQLSyntaxErrorException: [OWLS][SQLServer JDBC Driver][SQLServer]INSERT permission denied on object 'HSS_COMPONENT_TYPES', database 'hss', schema 'dbo'.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms