dbms_rls.drop_policy and dbms_rls.add_policy : dbms_rls « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. dbms_rls

SQL>
SQL> begin
  2     dbms_rls.drop_policy( 'UserName', 'T', 'T_POLICY' );
  3  end;
  4  /
begin
*
ERROR at line 1:
ORA-01918: user 'USERNAME' does not exist
ORA-06512: at "SYS.DBMS_RLS", line 59
ORA-06512: at line 2


SQL>
SQL> begin
  2     dbms_rls.add_policy
  3     ( object_name => 'T',
  4       policy_name => 'T_POLICY',
  5       policy_function => 'rls_examp',
  6       statement_types => 'select, insert',
  7       update_check    => TRUE );
  8  end;
  9  /
begin
*
ERROR at line 1:
ORA-00439: feature not enabled: Fine-grained access control
ORA-06512: at "SYS.DBMS_RLS", line 20
ORA-06512: at line 2


SQL>