11g Access Denied Error When Creating Discoverer Connection Using capi.sh (Doc ID 2066623.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Discoverer - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

Using Discoverer 11.1.1.7 the following issue occur :

Creation of discoverer connection does not work.

createPrivateDisco.sh - AccessControlException: access denied
Description: when creating a new Discoverer-Connection (/home/oracle/scripts/createPrivateDisco.sh) the following happens (connection is not available afterwards):

[oracle@portal scripts]$ ./createPrivateDisco.sh user_name OPS\$MANSCHEIN
Lauching capi with ...
SSO_USER user_name
DB_USER OPS$MANSCHEIN
DB_CONNECITON Production

Connection creation
{AppsSSOEnabled=true, ldapconnect=orcladmin/supervisor1, dbpasswd=group_wf, wlsurl=t3://portal.bmukk.gv.at:9004, sso_user=anna-simone.manschein, type=private, eul=OPS$DISCOVERER, dbuser=OPS$MANSCHEIN, wlsconnect=weblogic/supervisor1, sso_guid=161BE3A0CAE08FEBE05041900B0B7086, -create_conn=true, nonoid=false, dbname=prod, apps=false, showdetails=false, ldapurl=ldap://portal.bmukk.gv.at:3060, olap=false, cname=Production}
java.security.AccessControlException: access denied (java.lang.RuntimePermission oracle.discoverer.connections)
at java.security.AccessControlContext.checkPermission(AccessControlContext.java:374)
at java.security.AccessController.checkPermission(AccessController.java:546)
at oracle.discoiv.DiscoPermission.checkConnectionsPermission(DiscoPermission.java:62)
at oracle.discoiv.connections.passwordstore.PasswordStoreGateway.init(PasswordStoreGateway.java:118)
at oracle.discoiv.connections.passwordstore.PasswordStoreGateway.(PasswordStoreGateway.java:103)
at oracle.discoiv.capi.CapiCommandLineCreateRequest.execute(CapiCommandLineCreateRequest.java:76)
at oracle.discoiv.capi.CommandLineParser.main(CommandLineParser.java:281)

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