Oracle Database 11g: Controlling User Access and Managing Schema Objects

Overview/Description
To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.

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

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 11g: Controlling User Access and Managing Schema Objects

identify the steps for granting and revoking system and object privileges.

grant privileges to users in a given scenario.

recognize the steps for altering a table by adding, modifying, and dropping columns.

recognize the steps for adding and manipulating constraints and for creating indexes.

identify the steps for recovering your database using flashback, and for manipulating external data.

alter a table by dropping columns and adding constraints and indexes.