Oracle Database 11g Release 2: Storage Structures and User Security

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
90 minutes

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).

Objective

Tablespaces and Storage Structures

  • recognize how table data is stored
  • create a new tablespace
  • manage the storage of information in a database

Administering User Security

  • create and authenticate database user accounts
  • grant and manage privileges
  • create and manage roles
  • implement user profiles and user security
  • create a new tablespace
  • create and configure profiles
  • create a role

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.