- Docs »
- Module 6 - Creating and Managing Databases
-
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