Oracle PL/SQL for DBAs

Customizing FGA

Consider the code we used in the previous section to allow a table to take advantage of FGA:

    BEGIN
       DBMS_FGA.add_policy (object_schema      => 'HR',
                            object_name        => 'EMP',
                            policy_name        => 'EMP_SEL'
                           );
    END;

This example illustrates the most rudimentary form of the policy. In reality, you will have to customize FGA to handle your own particular auditing needs. In the following sections, I’ll show how policies can be customized.