Object Privileges

Object privileges allow users to perform particular and controlled actions on specific objects. They allow for a finer grain of control with respect to the objects that can be accessed and the functions that can be performed with those objects. You can allow a user to SELECT, INSERT, UPDATE, and DELETE from just a single table.

The only two privileges that you can grant concerning the manipulation of an existing sequence are SELECT and ALTER.

Table 17.2 shows all the object privileges that you should know for the exam.

Table 17.2. Oracle 9i Object Privileges
PrivilegeDescription
SELECTPermits grantee user to select data from granter's ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) 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.