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

1 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.