The User Status column shows the status of the Oracle account. This information is pulled directly from the Oracle database.
The following statuses can be displayed:
- OPEN indicates the account is active
- LOCKED indicates the account is locked
- EXPIRED (GRACE) indicates the account will expire shortly. If the user logs into Oracle directly, it will indicate exactly how many days remain before the account will expire. This is typical if your Oracle password must be changed shortly.
- EXPIRED indicates the account is expired.
| Info |
|---|
|
| The one exception is that a new Oracle account will show with an EXPIRED status until the user logs in with their temporary password and changes it. |
To lock or unlock a database user:- In User Administration, click Setup and then click DB Users.
You see a list of all the available database users. - To quickly find a user, click the Find button.
- To lock a database user, click the user whose User Status is OPEN and click Lock.
.png?version=1&modificationDate=1489592789736&cacheVersion=1&api=v2&width=1065)
Image Added - Notice Note that User Status is now LOCKED and the Lock option is grayed out.
The status change for the selected user has been processed.
.png?version=1&modificationDate=1489592833081&cacheVersion=1&api=v2)
Image Added - To unlock a database user, click the user whose User Status is LOCKED and click Unlock.
.png?version=1&modificationDate=1489592881506&cacheVersion=1&api=v2&width=962)
Image Added - Notice Note that User Status is now OPEN and the Unlock option is grayed out.
The status change for the selected user has been processed.
.png?version=1&modificationDate=1489592911185&cacheVersion=1&api=v2&width=962)
Image Added - If needed, refresh, print, or export[ |https://eagle-useradministration.helpdocsonline.com/refresh-print-export-data]the the information displayed in the workspace.
back to top
