Skip to main content

Oracle Database Hosted Applications

Connector name

agtorascript

Connector type

Executable with configuration SQL script

Type (UI field value)

Oracle Database (Script)

Target system versions supported / tested

agtorascript has been tested with Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production. Other versions may work.

Connector status / support

Bravura Security-Verified

This connector has been tested and is fully supported by Bravura Security.

Installation / setup

You must write a script file to define SQL commands used in the interaction between the agtorascript connector and the Oracle database. A sample script, agtorascript.cfg is contained in the samples directory. Note that any sample script may need customizations in order to work with your system.

No connector software is installed on the Oracle Applications server or the back-end database.

Bravura Security Fabric can manage passwords and/or accounts defined wholly inside Oracle application tables using the scripted connector for Oracle (agtorascript). This connector uses the Oracle client software to bind to the Oracle database server and issues SQL commands that you provide in a script file.

Bravura Security Fabric can perform operations on applications that have an Oracle back-end database by connecting to the Oracle server using OCI, and either directly updating user records (for example, SQL UPDATE) or by calling stored procedures.

Bravura Pass and Bravura Privilege can manage passwords on Oracle Applications / Oracle Financials by using the application’s stored procedures to update user profiles. Bravura Identity can create, delete, enable, disable, modify, and rename Oracle Applications users in one or more instances of Oracle Applications. All the basic operations are supported by calling the appropriate application’s stored procedures included by default in all Oracle Applications installations.

No connector software is installed on the Oracle Applications server or the back-end database.

The following Bravura Security Fabric operations are supported by this connector:

  • user verify password

  • user change password

  • get server information

  • administrator reset password

  • administrator reset+expire password

  • expire password

  • unexpire password

  • administrator verify password

  • verify+reset password

  • enable account

  • disable account

  • check account enabled

  • create account

  • delete account

  • expire account

  • check account expiry

  • unexpire account

  • lock account

  • unlock account

  • check account lock

  • add user to group

  • delete user from group

  • create group

  • delete group

  • add group to group

  • remove group from group

  • update attributes

  • list account attributes

  • List:

    • accounts

    • attributes

    • groups

    • members

    • computer objects

    • subscribers

    • update subscriber attributes/password

For a full list and explanation of each connector operation, see Connector operations.

This connector also supports custom operations, as defined in the configuration script .

Bravura Security Fabric can also manage Oracle database-level accounts using the connector for Oracle database (agtora). See Oracle Database for details.

Bravura Security Fabric can also manage accounts defined inside Oracle tables using the scripted connector for Oracle E-Business Suite (agtoraebiz).

In this section: