|
This course examines how to create database objects including sequences, synonyms, and indexes in Oracle9i SQL. It also covers sharing table data with other users through privileges and roles.
Objectives:
After completing this course, students will be able to:
- Create, modify, and delete sequences
- Create, modify, and delete synonyms
- Create, modify, and delete indexes
- Create, modify, and delete users
- Grant and revoke system and object privileges
- Create, grant, revoke, enable, disable, and delete roles
Topics:
- Working with sequences
- Working with synonyms
- Understanding indexes
- Working with indexes
- Understanding users
- Working with users
- Granting privileges
- Revoking privileges
- Creating, granting, and revoking roles
- Enabling, disabling, and dropping roles
|
