From the course: Oracle Database 12c: Security
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
View the audit trail - Oracle Database Tutorial
From the course: Oracle Database 12c: Security
View the audit trail
- [Instructor] After we have configured our new auditing policies and ransom actions which are supposed to trigger these auditing policies, it's time to see if our configuration is working as expected or not. So we'll start by connecting to the Oracle database as the SYSDBA user. Sqlplus sys/oracle at orcl as SYSDBA. We can monitor the unified auditing audit trail via the unified audit trail view. So let's run a query against this view, filtering for actions which were performed by either USER1 or USER2, in my database. You can find a query provided in your exercise file. Let's copy the query and paste it into our SQL plus window. As you can see, I am choosing to filter for audit trail records from actions generated by USER1 and USER2. You can of course omit this clause, and see all audit trail records for all actions performed by all database users. But for our demo purposes, that would be too much output from the query. So let's keep the condition in place, and as you can see I'm…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.