Begin
Dbms_Rls.Add_Policy(Object_Schema =>'Scott'
,Object_Name =>'T_Policy'
,Policy_Name =>'T_TestPolicy'
,Function_Schema =>'Scott'
,Policy_Function =>'Fn_GetPolicy'
,Statement_Types =>'Select,Insert,Update,Delete'
,Update_Check =>'True'
,Enable =>'True'
);
End;/
第2行初雪错误:
ORA-06550:第2行,第1列
PLS-00201:必须声明标识符'DBMS_RLS'
PL/SQL:Statement ignored谢谢
Dbms_Rls.Add_Policy(Object_Schema =>'Scott'
,Object_Name =>'T_Policy'
,Policy_Name =>'T_TestPolicy'
,Function_Schema =>'Scott'
,Policy_Function =>'Fn_GetPolicy'
,Statement_Types =>'Select,Insert,Update,Delete'
,Update_Check =>'True'
,Enable =>'True'
);
End;/
第2行初雪错误:
ORA-06550:第2行,第1列
PLS-00201:必须声明标识符'DBMS_RLS'
PL/SQL:Statement ignored谢谢
前面加个sys.试试?
或者用sys对你当前用户进行下授权