Quick Connect for Base Systems 2.4 - Administration Guide

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

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

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

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.