Invalid objects after revoking few privileges from PUBLIC
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.