Example 1: Creating a New User and Locking Her Account

    SQL> CREATE USER munroy IDENTIFIED EXTERNALLY
    cont> ACCOUNT LOCK
    cont> COMMENT IS 'User munroy starts job on'/
    cont> 'May 1, 2003.  Unlock when she starts';

    Example 2: Adding a profile to a user

    This example creates a new profile that defines the DEFAULT
    transaction and then assigns a profile while creating a new 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> create user JAIN identified externally profile READ_COMMITTED;
    SQL> show user JAIN;
          JAIN
          Identified externally
          Account is unlocked
          Profile: READ_COMMITTED
          No roles have been granted to this user