||Oracle Tips by Burleson
Chapter 10 Oracle Grants
will raise more questions than answers, due to
this ambiguity. However, if the grants auditing is enabled, the act
of granting and revoking the privilege will be captured too, and the
act can be discovered and explained.
Auditing Grants is a very important part of the
security framework applicable to any database, not just those under
the HIPAA regulations. In this chapter we learned how to:
Record the present privileges granted to the
users through a single script that can be run periodically.
Record the changes made to these grants using
AUDIT functionality, which will produce a track record of the
In the next chapter we will explore the
hitherto impossible task of auditing select statements using an
Oracle 9i feature called Fine Grained Auditing (FGA).
The above text is
an excerpt from:
Oracle Privacy Security Auditing
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
and has an
immediate download of working security scripts: