--創建敏感型別
BEGIN
DBMS_TSDP_MANAGE.ADD_SENSITIVE_TYPE (
sensitive_type => 'cn_type',
user_comment => 'Test data type');
END;
--添加敏感型別與資料列關聯
--schema_name,table_name,columm_name默認為‘%’
BEGIN
DBMS_TSDP_MANAGE.ADD_SENSITIVE_COLUMN(
schema_name => 'DBSEC',
table_name => 'T2',
column_name => 'CN',
sensitive_type => 'cn_type',
user_comment => 'Sensitive column addition of cn_type');
END;
--添加策略
DECLARE
redact_feature_options DBMS_TSDP_PROTECT.FEATURE_OPTIONS;
policy_conditions DBMS_TSDP_PROTECT.POLICY_CONDITIONS;
BEGIN
redact_feature_options ('object_schema') := 'DBSEC';
redact_feature_options ('object_name') := 'T2';
redact_feature_options ('statement_types') := 'SELECT';
redact_feature_options ('policy_name') := 'FGA_TEST';
DBMS_TSDP_PROTECT.ADD_POLICY ( 'FGAAA_CN', DBMS_TSDP_PROTECT.FGA, redact_feature_options,policy_conditions);
END;
DBMS_TSDP_PROTECT.ADD_POLICY這句報錯
ORA-45635: 找到無效的引數: ORA-06550: 第 1 行, 第 7 列:
PLS-00703: 串列中具有指定引數的多個實體
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored
ORA-06512: 在 "SYS.DBMS_TSDP_PROTECT", line 12
ORA-06512: 在 "SYS.DBMS_TSDP_PROTECT", line 115
ORA-06512: 在 line 6
直接使用DBMS_FGA.ADD_POLICY 是能成功的
begin
DBMS_FGA.ADD_POLICY (
object_schema => 'DBSEC',
object_name => 'T2',
policy_name => 'mypolicy1',
statement_types => 'SELECT'
);
end;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/22923.html
標籤：基礎和管理
上一篇：oracle 啟動提示ORA-27102: out of memory Linux-x86_64 Cannot allocate memory