O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required