Database Reference
In-Depth Information
Table 23.1
System Privileges (continued)
System Privilege
Description
EXECUTE ANY PROCEDURE
Run any procedure (useful for the DBA, who may
need to run Oracle-provided procedures).
CREATE ROLE
Create a role (see the next section in this chapter).
CREATE SEQUENCE
Create a sequence in your own schema.
SELECT ANY SEQUENCE
Query a sequence, using CURRVAL and
NEXTVAL, in any schema.
SELECT ANY TABLE
Query any schema's tables.
CREATE PUBLIC SYNONYM
Create a public synonym.
not need to know about all available privileges. However, you should know
the more common ones. Table 23.1 lists commonly used system privileges.
Object privileges are much easier to swallow because there are far fewer
of them. The basic object privileges available on tables are as shown in Table
23.2.
There are slightly different object privileges for different types of objects.
For example, views have nearly the same privileges as tables because they are
similar in structure. Packages and procedures, on the other hand, have
Table 23.2
Object Privileges
Object Privilege
Description
Allows retrieval of rows from a table.
SELECT
Allows adding of new rows to a table.
INSERT
Allows changing of rows in a table.
UPDATE
Allows deletion of rows from a table.
DELETE
Allows a user to create an index on a table using
the CREATE INDEX command.
INDEX
With respect to tables, allow execution of the
ALTER TABLE command and table structural
changes.
ALTER
Allows creation of table references constraints.
REFERENCES
