Module 6 - Creating and Managing Databases

Module Objectives

Object Hierarchy

Demo - Default Hierarchy

What Is A Database?

Creating Databases

Example - Creating Databases

Accessing a Database

Demo - Creating Databases

Users

Creating Users using psql or edb-psql

Creating Users Using EDB*Plus

Creating Users Using createuser

User Profile Management

Creating A User Profile

Privileges

GRANT Statement

Example - GRANT Statement

REVOKE Statement

Example - REVOKE Statement

Demo - Users and Permissions

What Is A Schema?

Benefits of Schemas

Creating Schemas

Demo - Creating Schemas

What Is A Schema Search Path?

Determine The Schema Search Path

Schema Search Path and Users

Set The Schema Search Path

Demo - Search Path

Object Ownership

Module Summary

Lab Exercise - 1

Lab Exercise - 2

Lab Exercise - 3

Demo - Sample Tables

Lab Exercise - 4