1  –  COMMENT IS 'string'

    Adds a comment about the role. SQL displays the text of the
    comment when it executes a SHOW ROLES statement. Enclose the
    comment in single quotation marks (') and separate multiple lines
    in a comment with a slash mark (/).

2  –  IDENTIFIED_EXTERNALLY

    The IDENTIFIED EXERNALLY clause indicates that SQL should inherit
    the roles defined by the facilities of the operating system,
    such as rights identifiers. When a session is started, any role
    that is defined externally is established as part of the current
    user's profile.

3  –  NOT_IDENTIFIED

    Indicates that the role is used only with the database. The
    database must have SECURITY CHECKING IS INTERNAL set before using
    this clause.

4  –  role-name

    A user-supplied name that you assign to the role. The special
    roles BATCH, DIALUP, INTERACTIVE, LOCAL, NETWORK, and REMOTE are
    reserved names that cannot be specified as a role-name.