//
archives

Security

This category contains 4 posts

Securing Oracle Database : Fine-Grained Auditing

In the previous posts [P1 & P2], we talk about Standard Auditing. In this post we talk about Fine-Grained Auditing (FGA). With standard auditing, you can easily captured all the objects and tables that were accessed and by whom, whether it was SELECT statement or any other DML statements such as DELETE, INSERT or UPDATE. … Continue reading

Securing Oracle Database – Standard Auditing (II)

In the previous post we talk about Standard Auditing and AUDIT_TRAIL parameter with the value set to DB and DB_EXTENDED. In this part we will talk about AUDIT_TRAIL parameter with OS, XML and XML_EXTENDED values. As we know that when AUDIT_TRAIL is set to OS, XML or XML_EXTENDED the audit_trail is write to the Operating … Continue reading

Securing Oracle Database – Standard Auditing (I)

Auditing helps you in monitor user’s database activity and records what was done in your database. It will help you to track their activity, how they performed it, what the command they used or their logon attempt whether successful or not. In short with the help of auditing you can able to track down any … Continue reading

Securing Oracle Database 11g

In this post we will see the new feature of Oracle Database 11g related to Security Management. Starting with Oracle Database 11g, you can monitor user accounts with the default passwords. Oracle 11g offers a new view DBA_USERS_WITH_DEFPWD. With the help of this view you get a listing of all user accounts that have default … Continue reading