A client recently asked me to find some information regarding the security algorithm used to encrypt the RPD in OBIEE 11g. After some investigation and attempts at trying to identify the encryption patterns, I came across a section in the Oracle BI 11g documentation for encryption in presentation services. A segment of this particular section goes on to say…
“Finally, a proprietary key-based encryption provides security to prevent unauthorized users from accessing the metadata repository.”
Well there is your answer, it is a proprietary encryption algorithm. This leads me to believe that the algorithm applied to the repository (RPD), utilizing the repository password most likely as a hash key, is most likely something like DES. No matter what algorithm really is I believe encrypting the repository in OBI 11g was a brilliant idea.
My opinion is that the RPD encryption is just a deterrent rather than an actual attempt at mission critical security lock-down. Because, if a professional hacker was able to get into your system and get at your RPD, chances are they would already be able to access a myriad of other sensitive bits of information and data, making the compromise of your RPD the least of your concerns.
Check out these BI Publisher tips including functions & calculations so you can understand more about the production and support of BI Publisher reports.
Ultimately the goal of commentary in OBIEE is to have a system for persisting feedback, creating a call to action, and recognizing the prolific users.