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

Ranjith1166

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

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

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

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.

Bhaskar Konar

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

Hi @Ranjith1166,

Can you please provide the product / tool set that you are using (i.e. Oracle Fusion HCM etc.) here. It'll help to understand the requirement and will be helpful to get potential resolution.

Thank you.

Ranjith1166

Thanks Mandeep

Ranjith1166

Thanks Bhaskar