OCA: Oracle 10g™ Administration I: Study Guide

6.8. Summary

Oracle 10g gives you a well-stocked toolkit for managing your users and securing your database. You create and manage user accounts with the CREATE, ALTER, and DROP USER statements. You can assign tablespace resources to be used for sorting that are different than those for tables or indexes. You can limit the disk, CPU, and memory resources that your users consume by employing tablespace quotas and kernel resource limits in user profiles.

To protect your data from unwanted access or manipulation, you can employee object and system privileges. You can create and use roles to make managing these database privileges easier. You can enable object, statement, privilege and fine-grained auditing to help you monitor and record sensitive ...