Oracle Database 11g: Storage Structures and User Security

Overview/Description
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 (hours)
2.5

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