Oracle Database 11g: Controlling User Access and Managing 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
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 11g: Controlling User Access and Managing 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.