Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 16 of 30
To remove a profile from the database.
For information on creating a profile, see "CREATE PROFILE".
You must have the DROP
PROFILE
system privilege.
The following statement drops the profile ENGINEER
:
DROP PROFILE engineer CASCADE;
Oracle drops the profile ENGINEER
and assigns the DEFAULT
profile to any users currently assigned the ENGINEER
profile.
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|