Oracle Database 11g Release 2: Storage Structures and User Security
Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
An Oracle database is divided into logical storage units called tablespaces. Oracle also provides Oracle-Managed Files (OMF), which eliminate the need for the DBA to directly manage the operating system files in the Oracle database. To access the database, a user must specify a valid database user account and successfully authenticate as required by that user account. What the user can execute once they are logged in is controlled by privileges granted to them, which can be system or object. Privileges can be better controlled by using roles and profiles, which control resource consumption and account status and passwords.This course describes the purpose and functions of tablespaces, and provides details on how to create and manage database user accounts. It also discusses creating privileges, roles, and profiles, as well as using the password file and assigning quotas to users. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Expected Duration (hours)
1.5
Lesson Objectives
Oracle Database 11g Release 2: Storage Structures and User Security
od_odas_a04_it_enus
Expertise Level
Intermediate