Thanks for the question, Anand.
Asked: November 27, 2015 - 3:48 pm UTC
Last updated: November 28, 2015 - 4:41 am UTC
Version: 11.2.0
Viewed 1000+ times
You Asked
Hi,
I want configure FGA for particular schema for all tables and for all columns but when I tried to configure.Getting below error.
for example :
EXECUTE DBMS_FGA.ADD_POLICY( -
OBJECT_SCHEMA => 'SCOTT', -
OBJECT_NAME => null, -
POLICY_NAME => 'SCOTT_TAB', -
AUDIT_CONDITION => null,-
AUDIT_COLUMN => null, -
ENABLE => TRUE, -
STATEMENT_TYPES => 'SELECT,UPDATE,DELETE');
ORA-01405: fetched column value is NULL
Audit information should be capture in sys.fga_log$ table for audit vault server(AVS) configuration.
Thanks,
Anand
and Connor said...
Object name is compulsory eg
SQL> begin
2 DBMS_FGA.ADD_POLICY(
3 OBJECT_SCHEMA => 'SCOTT',
4 OBJECT_NAME => null,
5 POLICY_NAME => 'SCOTT_TAB',
6 AUDIT_CONDITION => null,
7 AUDIT_COLUMN => null,
8 ENABLE => TRUE,
9 STATEMENT_TYPES => 'SELECT,UPDATE,DELETE');
10 end;
11 /
begin
*
ERROR at line 1:
ORA-01405: fetched column value is NULL
SQL> begin
2 DBMS_FGA.ADD_POLICY(
3 OBJECT_SCHEMA => 'SCOTT',
4 OBJECT_NAME => 'EMP',
5 POLICY_NAME => 'SCOTT_TAB',
6 AUDIT_CONDITION => null,
7 AUDIT_COLUMN => null,
8 ENABLE => TRUE,
9 STATEMENT_TYPES => 'SELECT,UPDATE,DELETE');
10 end;
11 /
PL/SQL procedure successfully completed.
You'll need to loop around for each table in SCOTT
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment