October 2005
Intermediate to advanced
454 pages
14h 44m
English
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.