Database Administration (MOSC)

MOSC Banner

Invalid objects after revoking few privileges from PUBLIC

edited May 7, 2014 10:55AM in Database Administration (MOSC) 7 commentsAnswered ✓

Hi All,

We have revoked the below privileges from PUBLIC, after which many objects become invalid.

SQL> REVOKE EXECUTE ON UTL_HTTP FROM PUBLIC;

SQL> REVOKE EXECUTE ON UTL_SMTP FROM PUBLIC;

SQL> REVOKE EXECUTE ON UTL_TCP FROM PUBLIC;

SQL> REVOKE EXECUTE ON UTL_INADDR FROM PUBLIC;

SQL> REVOKE EXECUTE ON UTL_FILE FROM PUBLIC;

UTLRP script is hanging and not compiling the object. Even running individual object compilation also taking time and not completing the task. 

This is also affecting the other user's DDL operations. Trying to add a column to application schema, which is not completing and hanging.

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