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.
Using standard auditing - Oracle Database Tutorial
From the course: Oracle Database 12c: Security
Using standard auditing
- [Instructor] In addition to creating very granular auditing policies in Oracle, as we saw in our previous videos, you can also enable something known as standard auditing, which allows us to audit SQL statement, privileges, and access to schema objects. Standard auditing in Oracle is more restricted, but very easy to configure. Let's see it in action. We'll open a connection to our ORCL-pluggable database as the sysdba user. So I'll type sqlplus sys slash oracle at orcl as sysdba. And in order to enable standard auditing we will run an audit command followed by a clause specifying what we want to audit. You can find the command included in your exercise file. So let's copy the command and paste it into our SQL Plus window. This command, as it is right now, will audit any of the following actions that are performed in the database: Selecting data from a table, inserting data to a table, deleting data from a table, and executing stored procedure. And another cool part is we can…
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.