6.9. Exam Essentials

Be familiar with the authentication methods. Database accounts can be authenticated by the database (identified by password), by the operating system (identified externally), or by an enterprise security service (identified globally).

Know how to assign default and temporary tablespaces to users. Assign default and temporary tablespaces with either a CREATE USER or an ALTER USER statement.

Be able to identify and grant object, system, and role privileges. Know the difference between these types of privileges and when to use each type.

Know the differences between the WITH ADMIN OPTION and the WITH GRANT OPTION keywords. The ADMIN option applies to role or system privileges, but the GRANT option applies to object privileges

Know how to enable roles. Know when a role needs to be enabled and how to enable it.

Be able to secure your database. Make sure you know how to lock down you database. Know which packages should be secured and how to secure them.

Know how to implement password security. An Oracle 10g database affords you several standard password security settings. Know what is available in a profile and what needs to be implemented in a password-verify function.

Know how to enable, disable and identify enabled auditing options. Be able to describe the types of auditing, how to enable them, and how to report on the audit trail.