4.1.1 Ensure 'EXECUTE' Is Revoked from 'PUBLIC' on 'DBMS_ADVISOR'

Information

As use of the DBMS_ADVISOR package could allow an unauthorized user to corrupt operating system files on the instance's host, use of this package should be restricted according to the needs of the organization.

Solution

To remediate this setting execute the following SQL statement. REVOKE EXECUTE ON DBMS_ADVISOR FROM PUBLIC;

See Also

https://workbench.cisecurity.org/files/601