Cleaning up remnants of a dropped user
After dropping a user, some things that get left beghind include scheduler logs and synonyms. Is it necessary to run extra scripts to remove thses too? What else gets left? How about ACL permissions (for things like UTL_TCP)?
When writing and testing build scripts it's essential that each time we start from a clean slate, but unfortunately it seems that simply dropping a user doesn't mop everything up.
Is there a script or utility somewhere that removes all traces of a user?
When writing and testing build scripts it's essential that each time we start from a clean slate, but unfortunately it seems that simply dropping a user doesn't mop everything up.
Is there a script or utility somewhere that removes all traces of a user?
0