Can The Oracle Reports Credential Store Be Used For Reports Database Logon ? (Doc ID 1907535.1)

Last updated on JULY 05, 2016

Applies to:

Oracle Reports Developer - Version 11.1.1.1.0 to 11.1.2.2.0 [Release 11g]
Information in this document applies to any platform.

Goal

There is information about the Oracle Reports Credential Store which can be managed over the Enterprise Manager console. It can savely store username/password key pairs. The question is now, if it is possible to store the username/password for a database login in this credential store which then can be used in a Report to automatically to log in to the database ?

When not having Single Sign On and OID  the alternative is that database username/password is stored for the automatic logon in the cgicmd.dat file, which is stored there un-encrypted.

When having Single Sign On and OID the alternative is to store database credentials in a RAD in OID and pass them to the report request via SSOCONN parameter.

Solution

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