REVOKE FROM PUBLIC hangs
We have AUDIT recommendations to remove privelgers that been granted to PUBLIC on most of all production database objects (tables, packages, store proc)
So far we created ROLES with appropriate privileges and assigned to all users/schemas no issues here. Now I am trying to execute following: REVOKE EXECUTE ON test_package FROM "PUBLIC"
to remove permissions from PUBLIC and some takes long time to complete it almost appears that it hangs.. It causes some internal errors and applications getting errors.
Here is my question. Does anybody know what caused some REVOKE from PUBLIC hang? Would restarting Database fix this issue?
This database 9i on AIX
Any input appreciated.