
92
|
Oracle DBA Pocket Guide
SEQUENCE
Provides the ability to work with sequences. There are no unique
privileges. Common privileges are CREATE [ANY], ALTER ANY,
DROP ANY, and SELECT ANY.
SESSION
Provides the ability to work with sessions. Unique privileges are:
ALTER RESOURCE COST
Gives the privilege to set the costs for session resources.
RESTRICTED SESSION
Gives the privilege to log on after the Oracle instance is
started with the STARTUP RESTRICT command.
Common privileges are CREATE and ALTER.
SYNONYM
Provides the ability to work with synonyms. There are no unique
privileges. Common privileges are CREATE [ANY] [PUBLIC],
DROP ANY, and DROP PUBLIC.
SYSTEM
Provides the ability to alter system parameters. There are no
unique privileges. The only common privileges is ALTER.
TABLE
Provides the ability to work with tables. Unique privileges are:
BACKUP ANY
Gives the privilege to use the Export utility on objects in other
users’ schemas.
COMMENT ANY
Gives the privilege to comment on any table, view, or column
in any schema.
INSERT ANY
Gives the privilege to insert rows into tables in other users’
schemas.