Database Security Products (MOSC)

MOSC Banner

Revoke default package (DBMS_LDAP, UTL_INADDR, OWA_UTIL, DBMS_CREDENTIAL .. ) from public

Dear Sir/Madam

As external audit recommend to revoke below from public

Doe it will impact database or system?

--REVOKE EXECUTE ON .. FROM PUBLIC;

--Network packages

REVOKE EXECUTE ON DBMS_LDAP FROM PUBLIC;

REVOKE EXECUTE ON UTL_INADDR FROM PUBLIC;

REVOKE EXECUTE ON UTL_TCP FROM PUBLIC;

REVOKE EXECUTE ON UTL_SMTP FROM PUBLIC;

REVOKE EXECUTE ON UTL_HTTP FROM PUBLIC;

REVOKE EXECUTE ON HTTPURITYPE FROM PUBLIC;


-- File System packages

REVOKE EXECUTE ON DBMS_ADVISOR FROM PUBLIC;

REVOKE EXECUTE ON UTL_FILE FROM PUBLIC;


-- Encryption Packages

REVOKE EXECUTE ON DBMS_OBFUSCATION_TOOLKIT FROM PUBLIC;

REVOKE EXECUTE ON DBMS_RANDOM FROM PUBLIC;

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