Call dbms_rls.add_policy to add policy to a table with statement type, update check and function schema : dbms_rls « System Packages « Oracle PL/SQL Tutorial

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

SQL>
SQL>
SQL> create table data_table
  2  (   some_data   varchar2(30),
  3      OWNER       varchar2(30) default USER
  4  )
  5  /

Table created.

SQL> begin
  2    dbms_rls.add_policy
  3     ( object_schema   => 'userName',
  4       object_name     => 'data_table',
  5       policy_name     => 'MY_POLICY',
  6       function_schema => 'TKYTE',
  7       policy_function => 'security_policy_function',
  8       statement_types => 'select, insert, update, delete' ,
  9       update_check    => TRUE,
 10       enable          => TRUE
 11     );
 12  end;
 13  /
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>
SQL> drop table data_table;

Table dropped.