Chat now with support
Chat with Support

Quick Connect for Base Systems 2.4 - Administration Guide

Installing One Identity Quick Connect for Base Systems Working with a delimited text file Working with an LDAP directory service Working with Microsoft SQL Server Working with Novell eDirectory Working with an OLE DB-compliant relational database Working with Oracle Database Working with Oracle user accounts Working with Sun One Directory Server Working with OpenDS Working with Red Hat Directory Server Working with MySQL database Working with IBM DB2 Working with an ODBC-compliant data source Working with an OpenLDAP directory service

Advanced

Working with Oracle user accounts > Modifying an existing Oracle user accounts connection > Advanced

This expandable item provides the following options that allow you to specify custom SQL queries which will automatically run each time One Identity Quick Connect Sync Engine has created, updated, or deleted a user account in Oracle Database:

  • SQL queries to run after user provisioned. Lists the SQL queries you want to run each time One Identity Quick Connect Sync Engine has created a user account in Oracle Database.
  • SQL queries to run after user updated. Lists the SQL queries you want to run each time One Identity Quick Connect Sync Engine has updated a user account in Oracle Database.
  • SQL queries to run after user deprovisioned. Lists the SQL queries you want to run each time One Identity Quick Connect Sync Engine has deleted a user account in Oracle Database.

Below each of these options you can use these buttons:

  • Add. Adds a new SQL query to the list.
  • Edit. Allows you to edit the SQL query selected in the list.
  • Delete. Deletes the SQL query selected in the list.

SQL queries run in the order they are listed. If necessary, you can rearrange the SQL queries in the lists: select an SQL query in the appropriate list, and then click the up or down arrow button to move the query as necessary.

Sample SQL queries

Working with Oracle user accounts > Sample SQL queries

The sample queries provided in this section are only applicable if One Identity Quick Connect Sync Engine is connected to the target Oracle Database system through the Oracle User Accounts Connector.

Sample query 1

Working with Oracle user accounts > Sample SQL queries > Sample query 1
Sample query 1

This SQL query illustrates how to call a specific Oracle stored procedure:

CALL "<ProcedureName>"('&USERNAME')

In this query:

  • ProcedureName specifies the name of the Oracle stored procedure you want to call.
  • USERNAME refers to the name of the attribute that uniquely identifies a user in the target Oracle Database system.

Sample query 2

Working with Oracle user accounts > Sample SQL queries > Sample query 2

This SQL query illustrates how to add a new entry to a particular table in the target Oracle Database system:

insert into DatabaseTable(ColumnName) values (upper('&USERNAME'))

In this query:

  • DatabaseTable specifies the name of the table into which the entry will be added.
  • USERNAME refers to the name of the attribute that uniquely identifies a user in the target Oracle Database system.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating