ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Clarity: How to find the history password of a specific user?

book

Article ID: 20567

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Description:

How can we find out the history of passwords that were created by our users in Clarity?

Solution:

A table exists on the database that stores the historical passwords of each Clarity user. This table stores information when the same user performed the password change for their own account through the Home > Account Settings page. If an administrator user performs a password change of another user in Administration > Resource properties, this change is not reflected on the table.

  1. Open "SQL Management Studio"

  2. Table Name: CMN_PWD_VERSIONS

    SELECT * FROM CMN_PWD_VERSIONS


  3. Each password change made by the user is stored on CMN_PWD_VERSIONS
    The above table stores the following:

    • ID
    • VALUE
    • USER_ID
    • CREATED_DATE
    • CREATED_BY
    • LAST_UPDATED_DATE
    • LAST_UPDATED_BY

  4. The column "VALUE" stores the encrypted passwords

  5. The column "USER_ID" corresponds to User_ID of Table "CMN_SEC_USERS"

    For related information, reference the following article:

    TEC561943 : Clarity: How are passwords stored in the database?

Environment

Release: ESPCLA99000-13.2-Clarity-Extended Support Plus
Component: