...
The following target system configuration parameters are available
General host parameters
Parameter | Description / Remarks |
---|---|
Server (mehrere getrennt mit ";") | Oracle server host name, can be multiple hosts delimited by the “;” character. All hosts use the same credentials and parameters as defined below |
Usernamen | User name for the database |
Passwort | Password for the database |
Port | Numeric port value, default is 1521 |
SID / Servicenamen | SID or Service name of the Oracle DB instance |
SQL parameters
See below for an explanation of the different SQL command types
...
Info |
---|
The Parameter IDENTITY_ID ist hard-coded and can’t be changed/defined. |
System connector method | SQL command type | Input parameters | Excepted return value | Description |
---|---|---|---|---|
SQL CreateIdentity | Stored procedure |
|
| Creates the user in the target system |
SQL GetIdentityParameters | Select query (function) |
|
| Returns all the user parameters of a user |
SQL CheckIdentityExists | Select query (function) |
|
| Checks if the user in the target system exists, if rows are returned → true, else false |
SQL FindObjectIdentifiersByAttributes | Select query (function) |
|
| Finds object identifiers of users by their attribute values. Returns all the object identifiers of users where the attributes values were found |
SQL UpdateIdentity (→ calls SQL GetIdentityParameters) | Stored procedure |
| - | Updates a user with the attribute values |
SQL DeleteIdentity | Stored procedure |
| - | Deletes a user by their identity identifier |
SQL ValidateCredentials | Not implemented | - | - | - |
SQL IsIdentityActivate | Select query (function) |
|
| Checks if the user in the target system is active, if rows are returned → true, else false |
SQL ActivateIdentity | Stored procedure |
| - | Activates a user in the target system |
SQL DeactivateIdentity | Stored procedure |
| - | Deactivates a user in the target system |
SQL SetIdentityPassword | Not implemented | - | - | - |
SQL IsPropertyValueUnique | Select query (function) |
|
| Checks if a property value is unique in the target system. There are 3 cases that gets checked to determine if the property value is unique:
|
Resource methods
System connector method | SQL command type | Input parameters | Excepted return value | Description |
---|---|---|---|---|
SQL CreateResource | Stored procedure |
|
| Creates the resource in the target system |
SQL GetResourceParameters | Select query (function) |
|
| Returns all the resource parameters of a resource |
SQL CheckResourceExists | Select query (function) |
|
| Checks if the resource in the target system exists, if rows are returned → true, else false |
SQL UpdateResource (→ calls SQL GetResourceParameters) | Stored procedure |
| - | Updates a resource with the attribute values |
SQL DeleteResource | Stored procedure |
| - | Deletes a resource in the target system |
SQL GetResources | Select query (function) |
|
| Returns resources of a specific system resource type, filtered by the text pattern and limited by the max results value |
SQL IsResourcePropertyValueUnique | Select query (function) |
|
| Checks if a property value is unique in the target system. There are 3 cases that gets checked to determine if the property value is unique:
|
Identity-resource membership methods
System connector method | SQL command type | Input parameters | Excepted return value | Description |
---|---|---|---|---|
SQL AddIdentityToResource | Stored procedure |
| - | Adds the user to the resource |
SQL RemoveIdentityFromResource | Stored procedure |
| - | Removes the user identity from the resource |
SQL GetResourcesFromIdentity | Select query (function) |
|
| Gets all the resources from the identity |
SQL GetIdentityMembersByResourceIdentifier | Select query (function) |
|
| Gets all the user identities from the resource |
SQL command types
Select Query (function)
...
Examples:
create_user
update_user
Identity functions
The following identity functions are supported:
Supported | |
create/delete identities | |
provisioning identities | |
update identities | |
provisioning identity updates | |
deprovision identities | |
cleanup of inactive identities active | |
check password changed active |
Resources functions
The following resource functions are supported:
Supported | |
create/delete resources | |
provision resources | |
update resources | |
provisioning resource changes | |
deprovisioning resources | |
provisioning resource allocations | |
deprovisioning resource allocations | |
provisioning resources-resource allocations | - |
Deprovisioning resource resource allocations | - |
Cleanup functions
The following cleanup functions are supported:
Supported | |
Is available in the expected/actual comparison log | - |
Clean up expected/actual | - |
Read back user account properties | |
Resource identity assignments Target system cleanup | - |
Resource-resource assignments Target system cleanup | - |
How-to Artikel
Filter by label (Content by label) | ||
---|---|---|
|
...