Oracle User Expiry Details Test
A user account in Oracle expires when the password_life_time configured for that user is reached. Upon expiry, Oracle automatically locks the user account, preventing that user from logging in. To avoid this, users need to be proactively alerted to the impending expiry of their accounts, thereby giving them time to reset the password_life_time configuration, if required. The Oracle Users Expiry Details test does just that. This test not only reports the number of expired users on an Oracle database server, but also reports the number of user accounts that are nearing expiry.
This test is disabled by default. To enable the test, go to the enable / disable tests page using the menu sequence : Agents -> Tests -> Enable/Disable, pick Oracle Database as the Component type, Performance as the Test type, choose this test from the disabled tests list, and click on the << button to move the test to the ENABLED TESTS list. Finally, click the Update button.
Note:
This test will not report metrics for an Oracle 12c CDB server.
Target of the test : An Oracle server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for the Oracle database server being monitored.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Expired users: |
Indicates the current number of expired users. |
Number |
Use the detailed diagnosis of this measure to know which user accounts have expired. |
Users nearing expiry: |
Indicates the number of users who will be expiring within the configured no of days. |
Number |
Use the detailed diagnosis of this measure to know which users are about to expire |