From the course: Oracle Database 12c: Security
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Testing audit polices - Oracle Database Tutorial
From the course: Oracle Database 12c: Security
Testing audit polices
- [Instructor] Now it's time to see if our new auditing policies, the ones we have created in our previous chapter, have been enabled and if they are working as expected. So let's connect to our Oracle database as user one. I'll type sqlplus user one slash secret at Orcl. Remember that we have reset the password for user one in our previous video. Let's create a new table. I'll type create table, and let's give it an appropriate name of audit test table. This table will have two columns. Maybe column one of a number data type, and column two of a varchar two data type. Keeping things as simple as possible. Let's also, while connected as user one, run a query against the my data subset view in users two schema. So I'll type select star from user two dot my underscore data, underscore subset view. Now let us reconnect to the database as user two and attempt to trigger the third audit policy, which we created in our previous video. So I'll type quit, change the connection string to user…
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.