![]() For example, the date 29-AUG-11 10.00 AM could appear as follows. XXXXX4328 function_parameters => DBMS_REDACT.REDACT_NUM_US_SSN_F5,ĩ99994328 function_parameters => '9,1,5',ĭate-time data types: Partially redacted datetime values can appear simply as different dates. The first example uses a predefined format that is designed for Social Security numbers in the NUMBER data type, and the second replaces the first five numbers with the number 9, starting from the first digit. Number data types: The partially redacted NUMBER data type Social Security number 987654328 could appear as follows. XXX-XX-4320 function_parameters => DBMS_REDACT.REDACT_US_SSN_F5, The first example uses a predefined format (in previous releases called a shortcut) for character data type Social Security numbers, and the second example replaces the first five numbers with an asterisk ( *) while preserving the hyphens ( -) in between the numbers. The code on the right specifies how to redact the character data: it specifies the expected input format of the actual data, the format to use for the display of the redacted output, the start position at which to begin the redaction, the character to use for the redaction, and how many characters to redact. The displayed output for partial data redaction can be as follows:Ĭharacter data types: When partially redacted, a Social Security number (represented as a hyphenated string within a character data type) with value 987-65-4320 could be redacted so that it is displayed as shown in the following examples. To specify partial redaction, you must set the DBMS_REDACT.ADD_POLICY procedure function_type parameter to DBMS_REDACT.PARTIAL and use the function_parameters parameter to define the partial redaction behavior. If you want to redact columns containing string values of variable length, then you must use regular expressions, as described in Regular Expressions to Redact Patterns of Data. Typically, you use this type of redaction for credit cards or ID numbers.īe aware that partial data redaction requires that your data width remain fixed. ![]() ![]() This type of redaction is useful for situations where you want it to be obvious to the person viewing the data that it was redacted in some way. ![]() You can set the position within the actual data at which to begin the redaction, the number of characters to redact starting from that position, and the redaction character to use. In partial data redaction, you redact portions of the displayed output. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |