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?
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.
I found the solution.
cmn_sec_users table has a column for user_status_id (active=200, inactive=201, lock=202)
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.
Dang - meeting slowed me down. David beat me to answer!