Random Redaction Policies in Oracle Redaction

Random Redaction Policies in Oracle Redaction

Random redaction provide the random data to the application each time when data is selected.

Syntax:

DBMS_REDACT.ADD_POLICY (
object_schema IN VARCHAR2 := NULL,
object_name IN VARCHAR2,
column_name IN VARCHAR2 := NULL,
policy_name IN VARCHAR2,
function_type IN BINARY_INTEGER := NULL,
expression IN VARCHAR2,
enable IN BOOLEAN := TRUE);

Note: For defining the random redaction policies, use function type as RANDOM
function_type => DBMS_REDACT.RANDOM

Example:


BEGIN
DBMS_REDACT.ADD_POLICY(
object_schema => 'HR',
object_name => 'login_history',
column_name => 'emp_username',
policy_name => 'redact_emp_rand_username',
function_type => DBMS_REDACT.RANDOM,
expression => 'SYS_CONTEXT(''USERENV'',''SESSION_USER'') = ''APP_USER''');
END;
/

SELECT emp_username FROM HR.login_history;
emp_username
----------
KBCE*KDfRT

Note: Random value pick any random value for show if policy is enabled, It pick according to the datatypes of the column in which policy is placed.

Advertisements

One thought on “Random Redaction Policies in Oracle Redaction

  1. Pingback: Oracle Redaction | Smart way of Technology

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.