 |
|
Oracle Tips by Burleson |
Chapter 11 Oracle Fine Grained Auditing
DELETE FGA$
SEE CODE
DEPOT FOR FULL SCRIPT
AND ROWNUM < 2;
Now the policy can be dropped normally using
dbms_fga.drop_policy procedure.
Again, use this trick at your own risk, this is
unsupported by Oracle Support.
A policy can be disabled, without being
dropped. This can be useful in several situations where the policy
needs to be temporarily suspended.
begin
dbms_fga.disable_policy (
object_schema=>'CLAIM_SCHEMA',
object_name=>'CLAIMS',
policy_name=>'CLAIM_AMOUNT');
end;
To enable it, use the corresponding:
begin
dbms_fga.enable_policy (
object_schema=>'CLAIM_SCHEMA',
object_name=>'CLAIMS',
policy_name=>'CLAIM_AMOUNT');
end;
These four procedures inside the dbms_fga
package handle all operations inside the FGA framework.
The above text is
an excerpt from:
Oracle Privacy Security Auditing
The
Final Word on Oracle Security
This is the only authoritative
book on Oracle Security, Oracle Privacy, and Oracle Auditing written
by two of the world’s leading Oracle Security experts.
This indispensable book is only
$39.95
and has an
immediate download of working security scripts:
|
