Example 1: Using Delimited Identification Mixed-Case Profile Names SQL> DROP PROFILE Decision_Support; %RDB-E-NO_META_UPDATE, metadata update failed -RDMS-E-PRFNEXISTS, a quota does not exist with the name "DECISION_SUPPORT" SQL> SET DIALECT 'SQL99'; SQL> DROP PROFILE "Decision_Support"; SQL> COMMIT; Example 2: Using CASCADE to remove assigned profiles from users This example demonstrates that there may be dependencies between profiles and user objects. The CASCADE action will remove the profile from all users to which is assigned. SQL> create profile DECISION_SUPPORT cont> comment is 'restrictions for read-only users' cont> default transaction read only cont> transaction modes (read only, shared); SQL> SQL> show profile DECISION_SUPPORT; DECISION_SUPPORT Comment: restrictions for read-only users Transaction modes (read only, shared) Default transaction read only SQL> SQL> create user FREEMAN cont> identified externally cont> profile DECISION_SUPPORT; SQL> SQL> show user FREEMAN; FREEMAN Identified externally Account is unlocked Profile: DECISION_SUPPORT No roles have been granted to this user SQL> SQL> drop profile DECISION_SUPPORT restrict; %RDB-E-NO_META_UPDATE, metadata update failed -RDMS-E-PRFINUSE, entry "DECISION_SUPPORT" is referenced by user "FREEMAN" SQL> SQL> drop profile DECISION_SUPPORT cascade; SQL> SQL> show user FREEMAN; FREEMAN Identified externally Account is unlocked No roles have been granted to this user SQL> SQL> commit;