Oracle Database 11g: Controlling User Access and Managing Objects

Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisite
Familiarity with data processing concepts and techniques

Expected Duration
110 minutes

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.

Objective

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.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.