
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.