Creating A Private Connection With The Discoverer Connections API (CAPI) Fails With 'Error message 'Problem in Authenticating the request. Check Username/Password ...'

(Doc ID 419805.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle Discoverer - Version to [Release 9.0.4 to 10.1.2]
Information in this document applies to any platform.
***Checked for relevance on 24-May-2012***


The (Unix) and capi.bat (Windows) give the ability to bulk load Discoverer connections into the orasso schema.

Executing or capi.bat script can fail with a security exception.

Syntax used:

<|capi.bat> -connect "<uid/pwd>"-create_conn -sso_user "<sso_user>" -
AppsSSOEnabled "<true|false>" -type "<type>" -cname "<connectionname>" -cdesc "<description>" -
olap "<true|false>" -apps "<true|false>" -dbuser "<connection_username>" -dbpasswd "<password>" -eul
"<eul name>" -dbname "<connect string>"



Error message (security Exception):

Problem in Authenticating the request. Check Username/Password
java.lang.SecurityException: access denied
(oracle.ias.repository.schemaimpl.CheckRepositoryPermission getOIDConnect)
verifyPermission(Unknown Source)
at oracle.ias.repository.SchemaManager.getOIDConnect(
at oracle.discoiv.capi.AuthenticateConnection.
at oracle.discoiv.capi.CommandLineParser.main(


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