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_property_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_property_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_property_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)

example:

select userescid AS IDENTITY_ID from kiam_px_user where userescid = {IDENTITY_ID}

• SQL replacement for identity identifier: {IDENTITY_ID}

• A user with their attribute values

Gets a single user with the attribute values