The code-obfuscation-toolkit allows you to obfuscate the source code of a variety of stored programs, including procedures, functions, package bodies, and type bodies. When wrapping an object, to further obfuscate the original code in the event that it is ever unwrapped, all comments and line breaks can also be removed.
I was perusing (yes, "perusing") the My Oracle Support Community Database Administration posts recently when I came across this one: "How to hide oracle database account password in a create user sql script". The poster had a problem that every database administrator has had to confront at one time or another: namely, how to embed a … Continue reading How to hide Oracle passwords in a script?
What if you have a lot of potential PII data and you need to enforce some additional safeguards on it? How do I make this information actionable, and better yet how do I automate that action as much as possible?
A co-worker of mine recently had a dilemma. He needed to have a scheduler job chain in one schema trigger a second scheduler job chain in another schema when it completed. He had already come up with some ideas on how to accomplish this with a variety of home-grown solutions and he wanted to run … Continue reading AQ Basics
I love Oracle's Connection Manager for its proxy filtering of Oracle Net connections, but it has one major flaw: it isn't integrated into Oracle's Cluster Ready Services (CRS) or Oracle Restart at all. When configured securely, Connection Manager requires a manually entered password to perform most maintenance and administrative functions, including startup and shutdown. If … Continue reading Connection Manager Auto Start