Database Administration (MOSC)

MOSC Banner

Emd_notification package body goes invalid.

edited Jun 22, 2009 1:51AM in Database Administration (MOSC) 3 commentsAnswered
  Hi all,

Based on the EM recommendation, I revoked execute on utl_file, utl_smtp, utl_tcp, utl_http and dbms_random from public.

After the revoke, i realised that the package body for emd_notifcation goes invalid. I tried compiling and it says 'emd_notification body compiled' but when i check for invalid objects, it still shows that package body of emd_notification is invalid.

Does the invalidation got any thing to do with the execute privileges that I revoke? How should i resolve the problem?

Thanks.

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