From the course: Oracle Database 12c: Security
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Fine-grained auditing - Oracle Database Tutorial
From the course: Oracle Database 12c: Security
Fine-grained auditing
- [Instructor] In addition to unified audit policies and standard auditing, which we saw earlier in our chapter, Oracle also include one other auditing capability, known as fine grained auditing, or FGA in short. Both unified auditing, standard auditing, and FGA, fine grained auditing, these are all auditing technologies that are built-in to the Oracle database and can be used depending on your use case. For some auditing requirements, you may choose to use unified auditing, while for others, you may choose fine grained auditing. Fine grained auditing, as the name suggests, enable granular audit policies to be associated with specific columns in your tables. So for example, we can choose to only audit when access is made to a credit card column in your customers table, instead of auditing and logging access to every single column in your table every time a query is executed. The concept here is that, perhaps, only specific columns in your tables are sensitive, while others are not. So…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.