в 13:45, 26 мая 2010

2010-05-26T13:45:46Z

Admin: 1 версия

2010-05-26T10:05:57Z

1 версия

Новая страница

== dbms_fga.add_policy==



<source lang="sql">
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>
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>
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></source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL Tutorial/System Packages/dbms fga - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия