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 ...
Get Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.