SCRIPT: How To Apply the Same Fine Grained Audit Policy To All Tables In A Schema.
(Doc ID 469007.1)
Last updated on JULY 18, 2023
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Goal
Unlike DBMS_RLS (VPD), DBMS_FGA does not support the notion of a policy group for FGA Policies. This package allows to create a group of audit policies with the same attributes for all (default) or a number of tables in a schema at the same time. Use a unique grouped_policy_name for each distinct group of audit policies you want to manipulate with this package. There's no additional metadata stored, so the idea is to adhere to the naming convention for the grouped_policy_name, then this package creates the policies with the names like GROUP_NAME000001 etc. The parameters are mapped directly to those available in DBMS_FGA with the same defaults. There's no exception handler so all usual exceptions from dbms_fga are raised as unhandled exceptions, there's one check to avoid duplicate group names per schema. If you refer to column names, naturally they must exist in all tables that are in the list select * from dba_tables where owner = '<object_schema>' and table_name like '<object_name>'.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| Requirements |
| Configuring |
| Instructions |
| Sample Code |
| Sample Output |