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:
Below each of these options you can use these buttons:
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.
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.
This SQL query illustrates how to call a specific Oracle stored procedure:
CALL "<ProcedureName>"('&USERNAME')
In this query:
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:
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center