Database Reference
In-Depth Information
ALTER Table, Sequence
DELETE Table, View
INDEX Table
INSERT Table, View
READ Dictionary
REFERENCE Table
SELECT Table, Sequence, View
UPDATE Table, View
EXECUTE PL/SQL Objects e.g. Functions,
Package etc.
Figure 2-21: Object privileges and corresponding database objects.
The way to interpret this table is, if you keep the above example
in your mind, you can grant ALTER, DELETE object privileges
on any table but you cannot grant READ on any table. This
implies to EXECUTE, one cannot grant EXECUTE privilege on
any table, view etc. its only meant for PL/SQL objects. On the
other hand, System privileges allow the ability to create, alter,
drop and manage database objects or features. There is a long list
of system privileges and for ease of study we have categorized
them in the following categories.
CREATE CLUSTER
CREATE ANY CLUSTER
ALTER ANY CLUSTER
DROP ANY CLUSTER
Cluster
ALTER DATABASE
ALTER SYSTEM
AUDIT SYSTEM
Database
CREATE TABLE
CREATE ANY TABLE
ALTER ANY TABLE
DROP ANY TABLE
SELECT ANY TABLE
UPDATE ANY TABLE
DELETE ANY TABLE
INSERT ANY TABLE
LOCK ANY TABLE
Table
Search WWH ::




Custom Search