DESCRIPTION AND BENEFITS

During this two-day HANDS-ON workshop you will:

• learn about and be able to explore ORACLE's™ security and control features
• carry out a series of structured hands-on activities showing you exactly how to check out the security of an ORACLE™ database system
• take away not only a valuable hands-on experience, but also a fully documented course manual and Audit Workpacks showing the detailed audit tests you need to perform and questions to ask when auditing an ORACLE™ system

Through a series of structured keyboard activities you will realise the full potential of hands-on training for auditors. We give you everything you need to audit the security of ORACLE™ versions 8i and 9i database systems.

We show you how ORACLE™ security works, how to use the system administration commands, how to control users' activities, and all about the inbuilt auditing facilities.

We'll also show you how to use SQL (Structured Query Language) to run simple but powerful audit interrogations.

WHAT WILL BE COVERED

HANDS-ON
Introducing ORACLE™ and security
• the ORACLE™ security model
• database design concepts
• ORACLE™ system and system files
••• • log files
••• • the control file
••• • the external password file
• power users and usage
• ORACLE™ database objects
• the data dictionary
••• • the audit tables and views
• user security
••• • categories of users
••• • viewing users on the system
••• • profiles, roles, permissions and priviliges
••• • operating system security
• backup and recovery of the database
• the ORACLE™ job scheduler
• the ORACLE™ security server (OSS)
• ORACLE™ and the web

HANDS-ON
Auditing ORACLE™ systems
• using the audit trail
••• • the audit sub-system master switch
••• • creating the audit trail
••• • viewing the audit settings
• triggering tables to obtain audit data
• laying a record-based audit trail
• extracting production data
• using SQL for audit

To Course Index Page

To Bookings Page