Syntax options:

    TRANSACTION MODES | NO TRANSACTION MODES

    TRANSACTION MODES provides the list of allowable transactions
    for this user. Please see the SET TRANSACTION MODES clause of the
    CREATE DATABASE and ALTER DATABASE statements for more details of
    txn-modes.

    The transaction modes specified may include modes disabled
    for all database users by CREATE, IMPORT, or ALTER DATABASE
    statements. However, only the subset allowed by both profile and
    database settings will be used. For instance, if the database
    specifies (READ ONLY, SHARED READ, PROTECTED READ) and the
    profile specifies (READ ONLY, SHARED), the session will be
    allowed the subset (READ ONLY, SHARED READ).