Oracle Audit and Security

2 days


Delegates will learn how Oracle is built and understand what the various categories of user do on the database and the risks they carry.

Hands on labs will show the students how to scan the system for objects, especially sensitive tables, and to find out who can do what to them.


This course is for security specialists and auditors who are aware that their companies use Oracle based products, but do not understand the database platform and therefore the risks it may carry.

This course is suitable for all recent versions of Oracle, up to and including 12c.


No prior knowledge of Oracle is expected but delegates should have a general understanding of how computers work.

Course Outline

  • Introducing Oracle
  • The database management system
  • The Oracle security model
  • Oracle SQL Developer and SQL*PLUS (Command Line)
  • Connecting to ORACLE
  • Commands available in SQL*PLUS
  • SQL code – the development life cycle
  • SQL Developer features and functions in Oracle 12c
  • The data dictionary
  • The Oracle System
  • Log files
  • Datafiles
  • Init.ora
  • The control file
  • Trace and alert files
  • User Security
  • User creation issues
  • Categories of users
  • Viewing users on the system
  • Profiles
  • Roles
  • Permissions and privileges
  • Passwords
  • Maintaining user accounts
  • Power user accounts - system, sys, internal
  • Startup and shutdown
  • Operating system security
  • Backup and Recovery of the Database
  • Strategy and tactics
  • Logging
  • Auditing the Database
  • The audit sub-system master switch
  • Creating the audit trail
  • Viewing the audit settings
  • Challenge and output
  • Managing audit data
  • Laying an audit trail
  • Extracting production data from the system
  • Database Triggers
  • Introduction to triggers
  • Audit triggers

Audit Workpack

New features in Oracle 12c

Related Courses


Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA, ATO of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Somerset Bath2 850 £850 2019-10-03
Somerset Bath2 850 £850 2019-12-02