SQL> begin
2 dbms_fga.add_policy(
3 object_schema=>'SA',
4 object_name=> 'TABLE_CASE',
5 policy_name=> 'SA_Audit',
6 audit_condition=> 'status = ''A''',
7 audit_column=> 'OBJID,S_TITLE,CASE_STATE2CONDITION',
8 handler_schema => 'SA',
9 handler_module=> 'FGA_HANDLER',
10 enable => TRUE,
11 statement_types => 'SELECT, UPDATE'
12 audit_trail => DBMS_FGA.DB+EXTENDED,
13 audit_column_opts => dbms_fga.all_columns);
14 end;
15 /
audit_trail => DBMS_FGA.DB+EXTENDED,
*
ERROR at line 12:
ORA-06550: line 12, column 1:
PLS-00103: Encountered the symbol "AUDIT_TRAIL" when expecting one of the
following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "," was substituted for "AUDIT_TRAIL" to continue.
SQL>
SQL> begin
2 dbms_fga.add_policy(
3 object_schema=>'SA',
4 object_name=> 'TABLE_CASE',
5 policy_name=> 'SA_Audit',
6 audit_condition=> 'status = ''A''',
7 audit_column=> 'OBJID,S_TITLE,CASE_STATE2CONDITION',
8 handler_schema => 'SA',
9 handler_module=> 'FGA_HANDLER',
10 enable => TRUE,
11 statement_types => 'SELECT, UPDATE'
12 audit_trail => DBMS_FGA.DB_EXTENDED,
13 audit_column_opts => dbms_fga.all_columns);
14 end;
15 /
audit_trail => DBMS_FGA.DB_EXTENDED,
*
ERROR at line 12:
ORA-06550: line 12, column 1:
PLS-00103: Encountered the symbol "AUDIT_TRAIL" when expecting one of the
following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "," was substituted for "AUDIT_TRAIL" to continue.
SQL> begin
2 dbms_fga.add_policy(
3 object_schema=>'SA',
4 object_name=> 'TABLE_CASE',
5 policy_name=> 'SA_Audit',
6 audit_condition=> 'status = ''A''',
7 audit_column=> 'OBJID,S_TITLE,CASE_STATE2CONDITION',
8 handler_schema => 'SA',
9 handler_module=> 'FGA_HANDLER',
10 enable => TRUE,
11 statement_types => 'SELECT, UPDATE'
12 audit_trail => 'DBMS_FGA.EXTENDED',
13 audit_column_opts => dbms_fga.all_columns);
14 end;
15 /
audit_trail => 'DBMS_FGA.EXTENDED',
*
ERROR at line 12:
ORA-06550: line 12, column 1:
PLS-00103: Encountered the symbol "AUDIT_TRAIL" when expecting one of the
following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "," was substituted for "AUDIT_TRAIL" to continue.
SQL>
SQL> begin
2 dbms_fga.add_policy(
3 object_schema=>'SA',
4 object_name=> 'TABLE_CASE',
5 policy_name=> 'SA_Audit',
6 audit_condition=> 'status = ''A''',
7 audit_column=> 'OBJID,S_TITLE,CASE_STATE2CONDITION',
8 handler_schema => 'SA',
9 handler_module=> 'FGA_HANDLER',
10 enable => TRUE,
11 statement_types => 'SELECT, UPDATE'
12 audit_trail => DBMS_FGA.EXTENDED,
13 audit_column_opts => dbms_fga.all_columns);
14 end;
15 /
audit_trail => DBMS_FGA.EXTENDED,
*
ERROR at line 12:
ORA-06550: line 12, column 1:
PLS-00103: Encountered the symbol "AUDIT_TRAIL" when expecting one of the
following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "," was substituted for "AUDIT_TRAIL" to continue.
SQL> begin
2 dbms_fga.add_policy(
3 object_schema=>'SA',
4 object_name=> 'TABLE_CASE',
5 policy_name=> 'SA_Audit',
6 audit_condition=> 'status = ''A''',
7 audit_column=> 'OBJID,S_TITLE,CASE_STATE2CONDITION',
8 handler_schema => 'SA',
9 handler_module=> 'FGA_HANDLER',
10 enable => TRUE,
11 statement_types => 'SELECT, UPDATE'
12 audit_trail => DBMS_FGA+EXTENDED,
13 audit_column_opts => dbms_fga.all_columns);
14 end;
15 /
audit_trail => DBMS_FGA+EXTENDED,
*
ERROR at line 12:
ORA-06550: line 12, column 1:
PLS-00103: Encountered the symbol "AUDIT_TRAIL" when expecting one of the
following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "," was substituted for "AUDIT_TRAIL" to continue.
SQL>
SQL> begin
2 dbms_fga.add_policy(
3 object_schema=>'SA',
4 object_name=> 'TABLE_CASE',
5 policy_name=> 'SA_Audit',
6 audit_condition=> 'status = ''A''',
7 audit_column=> 'OBJID,S_TITLE,CASE_STATE2CONDITION',
8 handler_schema => 'SA',
9 handler_module=> 'FGA_HANDLER',
10 enable => TRUE,
11 statement_types => 'SELECT, UPDATE'
12 audit_trail => 'EXTENDED',
13 audit_column_opts => dbms_fga.all_columns);
14 end;
15 /
audit_trail => 'EXTENDED',
*
ERROR at line 12:
ORA-06550: line 12, column 1:
PLS-00103: Encountered the symbol "AUDIT_TRAIL" when expecting one of the
following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "," was substituted for "AUDIT_TRAIL" to continue.
SQL>
SQL> begin
2 dbms_fga.add_policy(
3 object_schema=>'SA',
4 object_name=> 'TABLE_CASE',
5 policy_name=> 'SA_Audit',
6 audit_condition=> 'status = ''A''',
7 audit_column=> 'OBJID,S_TITLE,CASE_STATE2CONDITION',
8 handler_schema => 'SA',
9 handler_module=> 'FGA_HANDLER',
10 enable => TRUE,
11 statement_types => 'SELECT, UPDATE'
12 audit_trail => 'EXTENDED',
13 audit_column_opts => dbms_fga.all_columns);
14 end;
15 /
audit_trail => 'EXTENDED',
*
ERROR at line 12:
ORA-06550: line 12, column 1:
PLS-00103: Encountered the symbol "AUDIT_TRAIL" when expecting one of the
following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "," was substituted for "AUDIT_TRAIL" to continue.
SQL>
SQL> begin
2 dbms_fga.add_policy(
3 object_schema=>'SA',
4 object_name=> 'TABLE_CASE',
5 policy_name=> 'SA_Audit',
6 audit_condition=> 'status = ''A''',
7 audit_column=> 'OBJID,S_TITLE,CASE_STATE2CONDITION',
8 handler_schema => 'SA',
9 handler_module=> 'FGA_HANDLER',
10 enable => TRUE,
11 statement_types => 'SELECT, UPDATE'
12 audit_column_opts => dbms_fga.all_columns);
13 end;
14 /
audit_column_opts => dbms_fga.all_columns);
*
ERROR at line 12:
ORA-06550: line 12, column 1:
PLS-00103: Encountered the symbol "AUDIT_COLUMN_OPTS" when expecting one of the
following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "," was substituted for "AUDIT_COLUMN_OPTS" to continue.
SQL>
SQL> begin
2 dbms_fga.add_policy(
3 object_schema=>'SA',
4 object_name=> 'TABLE_CASE',
5 policy_name=> 'SA_Audit',
6 audit_condition=> 'status = ''A''',
7 audit_column=> 'OBJID,S_TITLE,CASE_STATE2CONDITION',
8 handler_schema => 'SA',
9 handler_module=> 'FGA_HANDLER',
10 enable => TRUE,
11 statement_types => 'SELECT, UPDATE'
12 audit_trail => 'DBMS_FGA.EXTENDED',
13 audit_column_opts => 'all_columns');
14 end;
15 /
audit_trail => 'DBMS_FGA.EXTENDED',
*
ERROR at line 12:
ORA-06550: line 12, column 1:
PLS-00103: Encountered the symbol "AUDIT_TRAIL" when expecting one of the
following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "," was substituted for "AUDIT_TRAIL" to continue.
SQL> statement_types => 'SELECT, UPDATE'
SP2-0734: unknown command beginning "statement_..." - rest of line ignored.
SQL>
SQL>
SQL> begin
2 dbms_fga.add_policy(
3 object_schema=>'SA',
4 object_name=> 'TABLE_CASE',
5 policy_name=> 'SA_Audit',
6 audit_condition=> 'status = ''A''',
7 audit_column=> 'OBJID,S_TITLE,CASE_STATE2CONDITION',
8 handler_schema => 'SA',
9 handler_module=> 'FGA_HANDLER',
10 enable => TRUE,
11 statement_types => 'SELECT, UPDATE'
12 audit_column_opts => 'all_columns');
13 end;
14 /
audit_column_opts => 'all_columns');
*
ERROR at line 12:
ORA-06550: line 12, column 1:
PLS-00103: Encountered the symbol "AUDIT_COLUMN_OPTS" when expecting one of the
following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "," was substituted for "AUDIT_COLUMN_OPTS" to continue.
please help me guys i tried in all way ,,,,