17,377
社区成员
发帖
与我相关
我的任务
分享
--创建敏感类型
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;
begin
DBMS_FGA.ADD_POLICY (
object_schema => 'DBSEC',
object_name => 'T2',
policy_name => 'mypolicy1',
statement_types => 'SELECT'
);
end;