Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
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.
Security
|
93
LOCK ANY
Gives the privilege to lock tables and views in other users’
schemas.
FLASHBACK ANY
Gives the ability to issue a SQL flashback query on any table,
view, or materialized view in other users’ schemas. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843