|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 24 of 26
PROFILE statement to remove a profile from the database.
You must have the
PROFILE system privilege.
Specify the name of the profile to be dropped.
Restriction on dropping profiles: You cannot drop the
CASCADE to deassign the profile from any users to whom it is assigned. Oracle automatically assigns the
DEFAULT profile to such users. You must specify this clause to drop a profile that is currently assigned to users.
The following statement drops the profile
app_user (created in "Creating a Profile: Example"):
Oracle drops the profile
app_user and assigns the
DEFAULT profile to any users currently assigned the