Clarity

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.

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.

thanks dave

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.

Dale

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