Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 52 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 288 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 111 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Need table and column information to get User account status & Locked status under security console.
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.
Best Answers
-
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.
0 -
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.
0 -
Hi @Ranjith1166,
Please take a look into the following Oracle doc if you are looking to identify the Locked Users:
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.
0
Answers
-
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.
0 -
Thanks Mandeep
0 -
Thanks Bhaskar
0