Oracle Database 10g: Users and Security Release 2

Overview/Description
To explain how to manage users, implement security, and audit database activity on an Oracle 10g database

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
3.3

Lesson Objectives

Oracle Database 10g: Users and Security Release 2

recognize how to create user accounts and profiles.

recognize how to grant privileges and assign quotas to users.

recognize how to create a role and assign it to a user.

administer user accounts on an Oracle 10g database.

recognize how to restrict access to an Oracle database.

recognize how to implement database security by configuring user profiles.

implement password security by configuring user profiles.

recognize how to monitor database activity using Oracle's built-in audit tools.

recognize how to implement fine-grained auditing in an Oracle 10g database.

audit database activity in an Oracle 10g database.