Example 1: Renaming a User

    SQL> create user KELLYN
    cont>   identified externally
    cont>   comment is 'User: Edward "Ned" Kelly';
    SQL>
    SQL> -- The alternate name must exists at the operating system level
    SQL> alter user KELLYN rename to N_KELLY;
    %RDB-E-NO_META_UPDATE, metadata update failed
    -RDMS-E-NOSUCHPRF, unknown profile user or role
    SQL>
    SQL> -- Use the new corporate user-id naming scheme
    SQL> alter user KELLYN
    cont>   rename to NKELLY;

    Example 2: Adding a profile to a user

    This example creates a new profile that defines the DEFAULT
    transaction and then assigns a profile to the user. The next time
    the user attaches to the database, the START DEFAULT TRANSACTION
    statement will use the defined profile instead of the standard
    READ ONLY default.

    SQL> create profile READ_COMMITTED
    cont> default transaction read write isolation level read committed wait 30;
    SQL> show profile READ_COMMITTED
          READ_COMMITTED
          Default transaction read write wait 30
            Isolation level read committed
    SQL> alter user JAIN profile READ_COMMITTED;
    SQL> show user JAIN;
          JAIN
          Identified externally
          Account is unlocked
          Profile: READ_COMMITTED
          No roles have been granted to this user