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;