Oracle DBMS_REDACT_INT
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented
AUTHID DEFINER
Dependencies
DBMS_REDACT DBMS_REDACT_LIB  
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtredacta.plb
Subprograms
 
ADD_POLICY
Undocumented dbms_redact_int.add_policy(
object_schema          IN VARCHAR2,
object_name            IN VARCHAR2,
policy_name            IN VARCHAR2,
policy_description     IN VARCHAR2,
column_name            IN VARCHAR2,
column_description     IN VARCHAR2,
function_type          IN BINARY_INTEGER,
function_parameters    IN VARCHAR2,
expression             IN VARCHAR2,
enable                 IN BOOLEAN,
regexp_pattern         IN VARCHAR2,
regexp_replace_string  IN VARCHAR2,
regexp_position        IN BINARY_INTEGER,
regexp_occurrence      IN BINARY_INTEGER,
regexp_match_parameter IN VARCHAR2,
current_user           IN VARCHAR2,
current_user_id        IN BINARY_INTEGER);
TBD
 
ALTER_POLICY
Undocumented dbms_redact_int.alter_policy(
object_schema          IN VARCHAR2,
object_name            IN VARCHAR2,
policy_name            IN VARCHAR2,
action                 IN BINARY_INTEGER,
column_name            IN VARCHAR2,
function_type          IN BINARY_INTEGER,
function_parameters    IN VARCHAR2,
expression             IN VARCHAR2,
regexp_pattern         IN VARCHAR2,
regexp_replace_string  IN VARCHAR2,
regexp_position        IN BINARY_INTEGER,
regexp_occurrence      IN BINARY_INTEGER,
regexp_match_parameter IN VARCHAR2,
policy_description     IN VARCHAR2,
column_description     IN VARCHAR2,
current_user           IN VARCHAR2,
current_user_id        IN BINARY_INTEGER);
TBD
 
APPLY_POLICY_EXPR_TO_COL
Undocumented dbms_redact_int.apply_policy_expr_to_col(
object_schema          IN VARCHAR2,
object_name            IN VARCHAR2,
column_name            IN VARCHAR2,
policy_expression_name IN VARCHAR2,
current_user           IN VARCHAR2,
current_user_id        IN BINARY_INTEGER);
TBD
 
CREATE_POLICY_EXPRESSION
Undocumented dbms_redact_int.create_policy_expression(
policy_expression_name        IN VARCHAR2,
expression                    IN VARCHAR2,
policy_expression_description IN VARCHAR2,
current_user                  IN VARCHAR2,
current_user_id               IN BINARY_INTEGER);
TBD
 
DISABLE_POLICY
Undocumented dbms_redact_int.disable_policy(
object_schema   IN VARCHAR2,
object_name     IN VARCHAR2,
policy_name     IN VARCHAR2,
current_user    IN VARCHAR2,
current_user_id IN BINARY_INTEGER);
TBD
 
DROP_POLICY
Undocumented dbms_redact_int.drop_policy(
object_schema   IN VARCHAR2,
object_name     IN VARCHAR2,
policy_name     IN VARCHAR2,
current_user    IN VARCHAR2,
current_user_id IN BINARY_INTEGER);
TBD
 
DROP_POLICY_EXPRESSION
Undocumented dbms_redact_int.drop_policy_expression(
policy_expression_name IN VARCHAR2,
current_user           IN VARCHAR2,
current_user_id        IN BINARY_INTEGER);
TBD
 
ENABLE_POLICY
Undocumented dbms_redact_int.enable_policy(
object_schema   IN VARCHAR2,
object_name     IN VARCHAR2,
policy_name     IN VARCHAR2,
current_user    IN VARCHAR2,
current_user_id IN BINARY_INTEGER);
TBD
 
FPM_MASK
Undocumented dbms_redact_int.fpm_mask(
input_format  IN VARCHAR2,
output_format IN VARCHAR2,
input_value   IN VARCHAR2,
masking_key   IN VARCHAR2,);
TBD
 
FPM_UNMASK
Undocumented dbms_redact_int.fpm_unmask(
input_format  IN VARCHAR2,
output_format IN VARCHAR2,
input_value   IN VARCHAR2,
masking_key   IN VARCHAR2,);
TBD
 
UPDATE,_FULL_REDACTION_VALUES
Undocumented dbms_redact_int.upDATE,_full_redaction_values(
number_val      IN NUMBER
binfloat_val    IN BINARY_FLOAT,
bindouble_val   IN BINARY_DOUBLE,
char_val        IN CHAR,
varchar_val     IN VARCHAR2,
nchar_val       IN NCHAR,
nvarchar_val    IN NVARCHAR2,
date_val        IN DATE,
ts_val          IN TIMESTAMP
tswtz_val       IN TIMESTAMP WITH TIME ZONE,
blob_val        IN BLOB,
clob_val        IN CLOB,
nclob_val       IN NCLOB,
current_user    IN VARCHAR2,
current_user_id IN BINARY_INTEGER);
TBD
 
UPDATE,_POLICY_EXPRESSION
Undocumented dbms_redact_int.upDATE,_policy_expression(
policy_expression_name        IN VARCHAR2,
expression                    IN VARCHAR2,
policy_expression_description IN VARCHAR2,
current_user                  IN VARCHAR2,
current_user_id               IN BINARY_INTEGER);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_REDACT
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx