Page Comparison

SQL CreateIdentity

Stored procedure

• Identity attributes, parameter names are taken from target_system_property_name in the system_identity_type_attribute table

• IDENTITY_ID
  Unique identifier of the identity from the target system

Creates the user in the target system

SQL GetIdentityParameters

Select query (function)

• SQL replacement for identity identifier: {IDENTITY_ID}

• SQL replacements for identity attributes: {target_system_identity_typeproperty_attribute name}

• All identity parameters from the SELECT query

Returns all the user parameters of a user

SQL CheckIdentityExists

Select query (function)

• SQL replacement for identity identifier: {IDENTITY_ID}

• Result row(s) or nothing

Checks if the user in the target system exists, if rows are returned → true, else false

SQL FindObjectIdentifiersByAttributes

Select query (function)

• SQL replacement for system identity type: {SYSTEM_IDENTITY_TYPE_ID}

• SQL replacements for attribute values: {target_system_identityproperty_type_attribute name}

• Result rows with column name IDENTITY_ID

Finds object identifiers of users by their attribute values.

Returns all the object identifiers of users where the attributes values were found

SQL UpdateIdentity

Stored procedure

• Identity identifier: IDENTITY_ID

• Identity attributes, parameter names are taken from target_system_property_name in the system_identity_type_attribute table

-

Updates a user with the attribute values

SQL DeleteIdentity

Stored procedure

• Identity identifier: IDENTITY_ID

-

Deletes a user by their identity identifier

SQL ValidateCredentials

Not implemented

-

-

-

SQL IsIdentityActivate

Select query (function)

• SQL replacement for identity identifier: {IDENTITY_ID}

• SQL replacements for identity attributes: {target_system_identity_typeproperty_attribute name}

• Result row(s) or nothing

Checks if the user in the target system is active, if rows are returned → true, else false

SQL ActivateIdentity

Stored procedure

• Identity identifier: IDENTITY_ID

-

Activates a user in the target system

SQL DeactivateIdentity

Stored procedure

• Identity identifier: IDENTITY_ID

-

Deactivates a user in the target system

SQL SetIdentityPassword

Not implemented

-

-

-

SQL IsPropertyValueUnique

Select query (function)

• SQL replacement for unique property: {UNIQUEPROPERTY}

• SQL replacement for unique property value: {UNIQUEPROPERTYVALUE}

• Result row(s) or nothing

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:

• Returing more than one row:

  • Not unique → false

• Returing 1 row:

  • If property value is on the user with the given user object id → Is unique → true

  • If the property value is on another user → Is unique → false

• Returning now rows:

  • Is unique → true

SQL GetIdentity

Select query (function)

• SQL replacement for identity identifier: {IDENTITY_ID}

• A user with their attribute values

Gets a single user with the attribute values

SQL CreateResource

Not implemented

GetResourceParameters

Not implemented

CheckResourceExists

• Unique resource identifier

Stored procedure

• Resource attributes, parameter names are taken from target_system_property_name in the system_resource_type_attribute table

• RESOURCE_ID
  Unique identifier of the resource from the target system

Creates the resource in the target system

SQL GetResourceParameters

Select query (function)

• SQL replacement for resource identifier: {RESOURCE_ID}

• SQL replacements for resource attributes: {target_system_property_name}

• All resource parameters from the SELECT query

Returns all the resource parameters of a resource

SQL CheckResourceExists

Select query (function)

• SQL replacement for resource identifier: {RESOURCE_ID}

• SQL replacements for resource attributes: {target_system_property_name}

• Result row(s) or nothing

Checks if the resource exists. Return nothing if it doesn’t.

UpdateResource

Not implemented

DeleteResource

Not implemented

GetResources

Not implemented

IsPropertyValueUnique

Not implemented

GetResourceMembersByResource

Not implemented

AddResourceToResource

Not implemented

RemoveResourceFromResource

Not implemented

FindObjectIdentifiersByAttributes

Not implementedin the target system exists, if rows are returned → true, else false

SQL UpdateResource

Stored procedure

• Resource identifier: RESOURCE_ID

• Resource attributes, parameter names are taken from target_system_property_name in the system_resource_type_attribute table

-

Updates a resource with the attribute values

SQL DeleteResource

Stored procedure

• Resource identifier: RESOURCE_ID

-

Deletes a resource in the target system

SQL GetResources

Select query (function)

• SQL replacement for system resource type: {SYSTEM_RESOURCE_TYPE_ID}

• SQL replacements for the search value: {textPattern}

• SQL replacements for maximun amount of results returned: {maxResults}

• Result row with the resource identifiers that were found with the column name RESOURCE_ID

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)

• SQL replacement for unique property: {UNIQUEPROPERTY}

• SQL replacement for unique property value: {UNIQUEPROPERTYVALUE}

• SQL replacement for system resource type: {SYSTEM_RESOURCE_TYPE_ID}

• Result row(s) or nothing

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:

• Returing more than one row:

  • Not unique → false

• Returing 1 row:

  • If property value is on the user with the given user object id → Is unique → true

  • If the property value is on another user → Is unique → false

• Returning now rows:

  • Is unique → true

SQL GetResource

Select query (function)

• SQL replacement for resource identifier: {RESOURCE_ID}

• Result row with the resource identifier that was found

Gets a single resource

SQL AddIdentityToResource

Stored procedure

• Identity identifier: IDENTITY_ID

• Resource identifier: RESOURCE_ID

-

Adds the user to the resource

SQL RemoveIdentityFromResource

Stored procedure

• Identity identifier: IDENTITY_ID

• Resource identifier: RESOURCE_ID

-

Removes the user identity from the resource

AddResourceToIdentity

• Unique user object id

• Unique resource object id

-

Adds the resource to the user

RemoveResourceFromIdentity

• Unique user object id

• Unique resource object id

-

Removes the user from the resource

GetResourcesFromIdentity

• Unique user object id

• List of resource identifiers

Adds the user identity to the resource

GetIdentityMembersByResourceIdentifier

• Unique resource object id

SQL GetResourcesFromIdentity

Select query (function)

• SQL replacement for identity identifier: {IDENTITY_ID}

• SQL replacement for the system resource type: {SYSTEM_RESOURCE_TYPE_ID}

• Result rows with the resources from the identity, column names to return:
  RESOURCE_ID → unique identifier of the resource
  RESOURCE_DISPLAY_NAME → display name of the resource

Gets all the resources from the identity

SQL GetIdentityMembersByResourceIdentifier

Select query (function)

• SQL replacement for resource identifier: {RESOURCE_ID}

• Result rows with the identities from the resource, column names to return:
  IDENTITY_ID → unique identifier of the identity

Gets all the user identities from the resource