Home > database >  Times wrong DBMS_TSDP_PROTECT add FGA strategy
Times wrong DBMS_TSDP_PROTECT add FGA strategy

Time:10-14

 
- create a sensitive type
The BEGIN
DBMS_TSDP_MANAGE. ADD_SENSITIVE_TYPE (
Sensitive_type=& gt; 'cn_type'
User_comment=& gt; 'Test data type');
END;

- add sensitive type and the associated data column
- schema_name, table_name, columm_name defaults to '%'
The BEGIN
DBMS_TSDP_MANAGE. ADD_SENSITIVE_COLUMN (
Schema_name=& gt; 'DBSEC,
Table_name=& gt; 'T2'
Column_name=& gt; 'CN'
Sensitive_type=& gt; 'cn_type'
User_comment=& gt; 'Sensitive column addition of cn_type');
END;

- add a policy
DECLARE
Redact_feature_options DBMS_TSDP_PROTECT. FEATURE_OPTIONS;
Policy_conditions DBMS_TSDP_PROTECT. Policy_conditions;
The BEGIN
DBSEC redact_feature_options (' object_schema) :=' ';
Redact_feature_options (' object_name) :='T2';
Redact_feature_options (' statement_types) :='SELECT';
FGA_TEST redact_feature_options (' policy_name) :=' ';
DBMS_TSDP_PROTECT. ADD_POLICY (' FGAAA_CN 'DBMS_TSDP_PROTECT. FGA, redact_feature_options, policy_conditions);
END;

DBMS_TSDP_PROTECT ADD_POLICY this sentence error
ORA - 45635: find the invalid arguments: the ORA - 06550: line 1, column 7:
PLS - 00703: the list with multiple instances of the specified argument
ORA - 06550: line 1, column 7:
PL/SQL Statement ignored
ORA - 06512: in the "SYS. DBMS_TSDP_PROTECT", line 12
ORA - 06512: in the "SYS. DBMS_TSDP_PROTECT", line 115
ORA - 06512: in the line 6

Direct use of DBMS_FGA ADD_POLICY is successfully
 
The begin
DBMS_FGA. ADD_POLICY (
Object_schema=& gt; 'DBSEC,
Object_name=& gt; 'T2'
Policy_name=& gt; 'mypolicy1'
Statement_types=& gt; 'SELECT'
);
end;
  • Related