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.
dbms_redact.add_policy(
object_schema IN VARCHAR2 := NULL,
object_name IN VARCHAR2,
policy_name IN VARCHAR2,
policy_description IN VARCHAR2 := NULL,
column_name IN VARCHAR2 := NULL,
column_description IN VARCHAR2 := NULL,
function_type IN BINARY_INTEGER := dbms_redact.full,
function_parameters IN VARCHAR2 := NULL,
expression IN VARCHAR2,
enable IN BOOLEAN := TRUE,
regexp_pattern IN VARCHAR2 := NULL,
regexp_replace_string IN VARCHAR2 := NULL,
regexp_position IN BINARY_INTEGER := 1,
regexp_occurrence IN BINARY_INTEGER := 0,
regexp_match_parameter IN VARCHAR2 := NULL);
CREATE OR REPLACE FUNCTION myredact RETURN BINARY_INTEGER AUTHID DEFINER IS
BEGIN
RETURN 1;
END myredact;
/
col pname format a20
col pexpr format a60
col pdesc format a30
col object_owner format a12
col object_name format a12
col column_name format a12
col column_description format a20
col function_type format a12
col policy_name format a18
col expression format a30
col policy_description format a20
SELECT * FROM sys.radm$;
SELECT * FROM sys.radm_td$;
SELECT object_owner, object_name, column_name, function_type, regexp_position, regexp_occurrence, column_description
FROM redaction_columns;
dbms_redact.alter_policy(
object_schema IN VARCHAR2 := NULL,
object_name IN VARCHAR2,
policy_name IN VARCHAR2,
action IN BINARY_INTEGER := dbms_redact.ADD_COLUMN,
column_name IN VARCHAR2 := NULL,
function_type IN BINARY_INTEGER := dbms_redact.FULL,
function_parameters IN VARCHAR2 := NULL,
expression IN VARCHAR2 := NULL,
regexp_pattern IN VARCHAR2 := NULL,
regexp_replace_string IN VARCHAR2 := NULL,
regexp_position IN BINARY_INTEGER := 1,
regexp_occurrence IN BINARY_INTEGER := 0,
regexp_match_parameter IN VARCHAR2 := NULL,
policy_description IN VARCHAR2 := NULL,
column_description IN VARCHAR2 := NULL);
Apply a column-specific Policy Expression to a column
dbms_redact.apply_policy_expr_to_col(
object_schema IN VARCHAR2 := NULL,
object_name IN VARCHAR2,
column_name IN VARCHAR2,
policy_expression_name IN VARCHAR2 := NULL);
dbms_redact.update_full_redaction_values(
number_val IN NUMBER := NULL,
binfloat_val IN BINARY_FLOAT := NULL,
bindouble_val IN BINARY_DOUBLE := NULL,
char_val IN CHAR := NULL,
varchar_val IN VARCHAR2 := NULL,
nchar_val IN NCHAR := NULL,
nvarchar_val IN NVARCHAR2 := NULL,
datecol_val IN DATE := NULL,
ts_val IN TIMESTAMP := NULL,
tswtz_val IN TIMESTAMP WITH TIME ZONE := NULL,
blob_val IN BLOB := NULL,
clob_val IN CLOB := NULL,
nclob_val IN NCLOB := NULL);