Add our policy to the EMP view : dbms_rls « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. dbms_rls
SQL>
SQL>
SQL> begin
  2      dbms_rls.add_policy
  3      ( object_name     => 'EMP',
  4        policy_name     => 'HR_APP_SELECT_POLICY',
  5        policy_function => 'HR_PREDICATE_PKG.SELECT_FUNCTION',
  6        statement_types => 'select' );
  7  end;
  8  /
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>








31.22.dbms_rls
31.22.1.Call dbms_rls.add_policy to add policy to a table with statement type, update check and function schema
31.22.2.Add our policy to the EMP view
31.22.3.dbms_rls.drop_policy
31.22.4.dbms_rls.shared_static
31.22.5.dbms_rls.drop_policy and dbms_rls.add_policy