Oracle Integration

Estimated reading: 3 minutes 264 views

The MyPass Connector for Oracle is used by the MyPass Cloud to reset passwords for internal database users on Oracle systems. This is based on either native Oracle users or users residing in different tables. The connector is installed along with the Gateway server but licensed individually and on per-user basis.

MyPass Cloud supports easy integration into multiple Oracle systems from a single implementation. The communication to the Oracle database is done from the Gateway server. The integration is implemented using TCP communication, and this can optionally be implemented with encryption (depending on the Oracle deployment). Technically, it connects to the database and executes a stored procedure with the actual logic to reset the password of the Oracle user. The stored procedure has to be installed before the connector will work. MyPass Cloud requires the following parameters to be configured to be able to access an Oracle server.

PARAMETER DESCRIPTION
Hostname
A fully qualified hostname, a hostname or an IP address
Port
The Port that the server is listening on for the specified instance (1521 default)
Database
The Database in which the Stored Procedure is implemented
Stored Procedure
The name of the Stored Procedure to be called
Account
The name for the account with privileges to execute “alter login...” commands
Password
The password for the account specified
Oracle Path on Gateway
The Path to the Oracle Instant Client Bin folder

The various parameters are not used by the Connector but are just used to construct a valid formatted Oracle Connection String. All parameters are stored in the Gateway server, and sensitive information like account, password and the connection string are stored with strong encryption.

Integration

MyPass Cloud provides different integration options. These are located on your Gateway server in the following installation directory. \FastPassCorp\FastPassGateway\bin\ConnectorOracle\

  • FPC_PasswordReset_ForDatabaseUsers.sql: This procedure (FPC_PasswordReset_ForDatabaseUsers) can be used out of the box to reset password on Oracle native users (The privileged user account must have Alter User Rights).
  • FPC_PasswordReset_ForTableUsers.sql: Holds an example on handling passwords when they are stored in a table. The example creates a small example table and installs the procedure FPC_PasswordReset_TableUser
  • FPC_PasswordReset_EBSUser.sql: This procedure must be used for Oracle E-Business Suite integration

To install the stored procedure, you can use either Application Express SQL Workshop, SQL Developer tools or the command line. If you require any assistance in this process, please reach out to your MyPass Cloud engineer.

Logging

The connector logs operations to a log file. The location of the log is \FastPassCorp\logs\Gateway-UserRepository-Oracle.log, and the LogLevel is by default “Debug” but can be customized from the registry. Logging will never contain passwords or other sensitive information.