Object Privileges

Object privileges allow you to access or manipulate objects in the database. Depending upon the type of object, different object privileges apply. Table 6.1 shows the mapping of object privileges to object types.

Table 6-1. Object Privileges Allowed by Object Type

Object Option

Object Type Applicable

ALTER

Table, sequence

DELETE

Table, view, snapshot

EXECUTE

Package, procedure, function, library

INDEX

Table, snapshot

INSERT

Table, view, snapshot

READ (Oracle8 only)

Directory

REFERENCES

Table

SELECT

Table, view, sequence, snapshot

UPDATE

Table, view, snapshot

By default, only the owner of any object automatically has all object privileges for an object. The owner must grant access to the object to other users or roles in order for other users to access the object. The exception to this rule is that someone with the DBA role or with one of the system privileges that allow you to manipulate objects in any schema (they are listed in Table 15.4 in Chapter 15, which describes privileges in some detail) will be able to access the schema object directly.

Get Oracle Database Administration: The Essential Refe 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.

Start your free trial