Clarity PPM1

Expand all | Collapse all

Locked flag about a resource

Jump to Best Answer
  • 1.  Locked flag about a resource

    Posted 09-25-2017 10:49 AM

    Where can I find in the database, information about a resource status? I'm interested in "locked" users.

    The SRM_RESOURCES table has a is_active column with possible values of (0 = inactive or 1= active) if the account is locked it will also show 0. 

    In which table can I find the locked flag?

    Thanks.



  • 2.  Re: Locked flag about a resource
    Best Answer

    Posted 09-25-2017 11:02 AM

    locked users (not resources) are denoted by CMN_SEC_USERS.USER_STATUS_ID being set to 202

     

    200 = active

    201 = inactive

    202 = locked

     

    the application keeps the resource status in sync with the matching user status (join is on user_id in the srm_resource table) - an active resource can be either an active or locked user, an inactive user will always be an inactive resource.



  • 3.  Re: Locked flag about a resource

    Posted 09-25-2017 11:08 AM

    thanks dave



  • 4.  Re: Locked flag about a resource

    Posted 09-25-2017 11:06 AM

    I found the solution.

    cmn_sec_users table has a column for user_status_id (active=200, inactive=201, lock=202)



  • 5.  Re: Locked flag about a resource

    Posted 09-25-2017 11:08 AM

    Check cmn_sec_users.user_status_id for account status.

     

    You'll find 3 numbers there:  200 (active), 201 (inactive) and 202 (locked).

     

    Used to be more clear, IMO, in days gone past, where resources were placed on projects and users were people that logged in - back then, on Application side, one would find "Resources" as everyone sees them today.  On Admin side, instead of "Resources" one would see "Users" - I think this terminology was more clear and lined up with the table names better.

     

    Dale



  • 6.  Re: Locked flag about a resource

    Posted 09-25-2017 11:11 AM

    Dang - meeting slowed me down.  David beat me to answer!