Images

14

Controlling User Access

CERTIFICATION OBJECTIVES

14.01     Differentiate System Privileges from Object Privileges

14.02     Grant Privileges on Tables and on a User

14.03     Distinguish Between Privileges and Roles

   ✓        Two-Minute Drill

Q&A     Self Test

This chapter explores the subject of user access and the privileges associated with performing actions in the database. Every action performed by any user account requires a corresponding privilege or set of privileges to perform that action. There are two categories of privileges. System privileges are required to perform a task in the database; object privileges are required to use ...

Get OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) 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.