Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
CREATE TYPE to
DROP ROLLBACK SEGMENT, 24 of 26
Use the DROP
PROFILE
statement to remove a profile from the database.
You must have the DROP
PROFILE
system privilege.
drop_profile::=
drop_profile
Specify the name of the profile to be dropped.
Restriction: You cannot drop the DEFAULT
profile.
Specify 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.
DROP
PROFILE
Example
The following statement drops the profile app_user
(created in "CREATE PROFILE Example"):
DROP PROFILE app_user CASCADE;
Oracle drops the profile app_user
and assigns the DEFAULT
profile to any users currently assigned the app_user
profile.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|