Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007)

Chapter 13. Security (DDL)

Terms You Need to Understand

• ✓ User

• ✓ Schema

• ✓ CREATE USER

• ✓ Default tablespaces

• ✓ Role

• ✓ CREATE ROLE

• ✓ Grant privilege

• ✓ Revoke privilege

• ✓ Object privilege

• ✓ System privilege

• ✓ SYS user

• ✓ SYSTEM user

• ✓ CONNECT role

• ✓ RESOURCE role

Concepts You Need to Master

• ✓ Creating users

• ✓ Access privileges between the SYS and SYSTEM users

• ✓ The difference between object and system privileges

• ✓ The importance of the CREATE SESSION system privilege

• ✓ Object privilege cascade revokes

• ✓ System privilege cascade revokes

• ✓ Roles group privileges for easy security maintenance

• ✓ CONNECT and RESOURCE roles and who gets them

This chapter deals with Oracle database security issues. Details included are schemas (users), roles for grouping privileges, and finally ...