Chapter 6. User Administration and Security
ORACLE DATABASE 10G: ADMINISTRATION I EXAM OBJECTIVES COVERED IN THIS CHAPTER:
Administering Users
Create and manage database user accounts.
Create and manage roles.
Grant and revoke privileges.
Control resource usage by users.
Oracle Database Security
Apply the principle of least privilege.
Manage default user accounts.
Implement standard password security features.
Audit database activity.
Register for security updates.
NOTE
Exam objectives are subject to change at any time without prior notice and at Oracle's sole discretion. Please visit Oracle's Training and Certification website (http://www.oracle.com/education/certification/) for the most current exam objectives listing.
DBAs must maintain the security, integrity, performance, and availability of their databases. In this chapter, you will learn about managing database security: how to manage user accounts, implement password expiration and complexity rules, and configure security policies using object, system, and role privileges. To further enhance your ability to monitor and manage database access, you will learn how to use auditing mechanisms to fine-tune your security policy, identify attempts to access areas of your database that the user is not authorized to visit, and identify intrusion attempts.