Database Security Products (MOSC)

MOSC Banner

Security Remediation

edited Jul 18, 2020 5:01AM in Database Security Products (MOSC) 8 commentsAnswered
 I am attempting to remediate multiple security vulnerabilites in our Oracle databases.  I have developed the following script and ran it against a test database.  Immediately after running the script I cannot log into the OEM(DBconsole) with SYS or SYSTEM or my ADMIN account.  I experience the error message: "The application requires more database privileges than you currently have been granted".

I am not able to identify what command would have affected my ability to login to the OEM. 

Oracle version: 10.2.0.4

Script:

REVOKE EXECUTE ON SYS.DBMS_JOB FROM PUBLIC;
DROP USER WMSYS CASCADE;
REVOKE CREATE ANY TABLE FROM SYSMAN;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center