![]() ![]() Do not be surprised when your obfuscated system behaves entirely differently from your "clear text" system - clustering factors, data lengths, distributions of values - all will be radically different. ![]() Think about things like indexes and such.ĭon't forget, as soon as you start obscuring data, you start to lose the natural distribution of data. You actually need to physically obscure the data itself prior to storage (and it had better be a one way obfuscation). No, we can "hide" the information (Oracle 9i provides for row hiding and Oracle 10g provided for row and/or column hiding)īut data obfuscation - no, it cannot do that. There are various mechanisms available - data masking and data redaction.Ĭheck out the whitepaper for examples and details If you want to, I can post its name here. I found a third party software that will do the job. Does Oracle supply anything for that purpose at all ? I tried to find but didn't have much success. It doesn't really need to make sense, it doesn't need to be readable. In the development environment, the same information needs to be masked for something like: In the production environment, if we do a select on customer, the result would be without any surprise: Insert into customer values('Doe', 'John', '10 someroad st') Does Oracle provide a package or function for data masking ? For example, in a development environment, for data protection purposes, the information of the table customer needs to be masked.Ĭreate table customer (last_name varchar2(25), first_name varchar2(25), address varchar2(25)) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |