Mega Code Archive
Dbms_rls drop_policy
<![CDATA[
SQL>
SQL> begin
2 -- drop the policy first.
3 dbms_rls.drop_policy (
4 object_schema => 'HR',
5 object_name => 'EMP',
6 policy_name => 'EMP_POLICY'
7 );
8
9 dbms_rls.add_policy (
10 object_schema => 'HR',
11 object_name => 'EMP',
12 policy_name => 'EMP_POLICY',
13 function_schema => 'RLSOWNER',
14 policy_function => 'AUTHORIZED_EMPS',
15 statement_types => 'INSERT, UPDATE, DELETE, SELECT',
16 update_check => true,
17 sec_relevant_cols => 'SAL, COMM'
18 );
19 end;
20 /
begin
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_RLS", line 59
ORA-06512: at line 3
]]>