Oracle Database 11g: Storage Structures and User Security

This course is included in our On-demand training solution.

Overview

identify the steps for maintaining storage structures and automating storage management in Oracle Database 11g, and for managing privileges, roles, and other security features for users.

Target Audience

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

Prerequisites

A working knowledge of SQL

Expected Duration

150 min.

Course Objectives

Oracle Database 11g: Storage Structures and User Security

  • recognize the purposes of table spaces and datafiles.
  • recognize the steps for creating a new tablespace.
  • recognize how to manage the storage of information by maintaining tablespaces and viewing their information, and automating manual storage using Automatic Storage Management (ASM).
  • view tablespace information and create a new tablespace.
  • recognize the steps for creating and authenticating database user accounts.
  • recognize the steps for granting and revoking privileges and creating and managing roles.
  • recognize the steps for creating and managing profiles, implementing password security, and assigning quotas.
  • grant privileges to users in a given scenario.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?