Mega Code Archive
Dbms_fga add_policy
<![CDATA[
SQL>
SQL> begin
2 dbms_fga.add_policy (
3 object_schema => 'HR',
4 object_name => 'EMP',
5 policy_name => 'EMP_SEL',
6 audit_column => 'SAL, COMM',
7 audit_condition => 'SAL >= 150000 OR EMPID = 100'
8 );
9 end;
10 /
begin
*
ERROR at line 1:
ORA-00439: feature not enabled: Fine-grained Auditing
ORA-06512: at "SYS.DBMS_FGA", line 17
ORA-06512: at line 2
SQL>
SQL> begin
2 dbms_fga.add_policy (
3 object_schema => 'HR',
4 object_name => 'EMP',
5 policy_name => 'EMP_DML',
6 audit_column => 'SALARY, COMM',
7 audit_condition => 'SALARY >= 150000 OR EMPID = 100',
8 statement_types => 'SELECT, INSERT, DELETE, UPDATE'
9 );
10 end;
11 /
begin
*
ERROR at line 1:
ORA-00439: feature not enabled: Fine-grained Auditing
ORA-06512: at "SYS.DBMS_FGA", line 17
ORA-06512: at line 2
SQL>
SQL> begin
2 dbms_rls.add_policy (
3 object_name => 'EMP',
4 policy_name => 'EMP_POLICY',
5 function_schema => 'HR',
6 policy_function => 'AUTHORIZED_EMPS',
7 statement_types => 'INSERT, UPDATE, DELETE, SELECT',
8 update_check => true
9 );
10 end;
11 /
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>
]]>