Need table and column information to get User account status & Locked status under security console.

Question

I have a requirement to get user account status whether account is active or inactive and user locked status, whether account is locked or unlocked.

Need table information to get this information. Is there any tables to store these information.

TIA.

MandeepGupta · Accepted Answer

https://community.oracle.com/products/oracleanalytics/discussion/25360/need-table-and-column-information-to-get-user-account-status-locked-status-under-security-console

Hi Ranjith,

Suspended flag in per_users indicates whether the user is active or inactive. However, there is no such flag to know the locked status of a user.

Thanks.

MandeepGupta · Accepted Answer

https://community.oracle.com/products/oracleanalytics/discussion/25360/need-table-and-column-information-to-get-user-account-status-locked-status-under-security-console

Hi Ranjith,

You can refer below links for more details:

Report to get list of users who are locked — Cloud Customer Connect

ORACLE FUSION HCM QUERY TO GET USER ACCOUNT LOCKED — Cloud Customer Connect

Thanks.

Bhaskar Konar · Accepted Answer

Hi @Ranjith1166,

Please take a look into the following Oracle doc if you are looking to identify the Locked Users:

https://support.oracle.com/knowledge/Oracle%20Cloud/2496969_1.html

Additionally please take a look into the following discussion.

What table/field stores user account locked info? — Cloud Customer Connect

Hope this help.

Thank you.