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
Security
|
87
DROP PROFILE
Deletes an existing profile.
DROP PROFILE profile_name [CASCADE]
If CASCADE is specified, the profile will be desassigned from any
active users and replaced with the DEFAULT profile. You must
use this clause to drop a profile for a currently active user.
Privileges
A privilege is a right that is assigned to an individual user or
role. There are two basic types of privileges:
System privileges give the user or role the ability to per-
form certain system operations.
Schema object privileges give the user or role access privi-
leges on individual schema objects.
System privileges relate to the Oracle instance as a whole (for
example, a privilege on all of a given type of object, such as
all tables), while schema privileges relate to a specific schema
object within an Oracle database (for example, a particular
table).
System privileges
The following list describes privileges that apply to many
Oracle system privilege types.
ANY
Gives the privilege to perform the action on objects in
any schema. Without this keyword, a privilege is granted
only on objects within the user’s schema. By default, the
ANY keyword gives the user privileges on all objects in
all schemas, including the SYS schema. To prevent access
to the SYS schema with the ANY privilege, you can set
the O7_DICTIONARY_ACCESSIBILITY initialization
parameter to FALSE.
88
|
Oracle DBA Pocket Guide
ALTER
Gives the privilege to alter ...
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