Drop Administrative User
Overview
Overview
I had installed the PERFSTAT user (for StatsPack). I was unable to drop the user because it was classified as an administrative user.
References
References
Issue
Issue
I tried to drop the PERFSTAT user as follows:
The output was:
Solution
Solution
Following the advice in ORA-28014: Cannot Drop Administrative Users (Doc ID 1566042.1), I ran the following command:
I reran the following SQL command:
This worked.