declare
-- 参数定义:关于参数含义 可以进入function 查看
str_schema varchar2(20) := '对象模式——拥有表/视图的模式,当前用户为空';
str_obj_name varchar2(20) ;
str_group_name varchar2(20);
str_policy_name varchar2(30);
begin
-- 循环 drop
for item in (select * from all_policies ) loop
str_obj_name := item.object_name;
str_group_name := item.policy_group;
str_policy_name := item.policy_name;
dbms_rls.drop_grouped_policy(object_schema => str_schema,object_name => str_obj_name,
policy_group => str_group_name,policy_name => str_policy_name);
end loop;
for item in (select * from ALL_POLICY_GROUPS) loop
str_obj_name := item.object_name;
str_group_name := item.policy_group;
str_policy_name := str_schema;
dbms_rls.delete_policy_group(str_schema,str_obj_name,str_group_name);
end loop;
end;
/