SQL$HELP72.HLB  —  CREATE  USER  Arguments

1  –  ACCOUNT lock-option

    Syntax options:

    ACCOUNT LOCK | ACCOUNT UNLOCK

    The ACCOUNT LOCK clause disables access to the database by the
    user for whom the CREATE USER statement is being applied. The
    ACCOUNT UNLOCK clause allows that user access to the database.

    The ACCOUNT UNLOCK clause is the default.

2  –  COMMENT IS 'string'

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

3  –  IDENTIFIED_EXTERNALLY

    Indicates that the user will be authenticated through the
    operating system.

4  –  PROFILE

    Syntax options:

    PROFILE | NOPROFILE

    Identifies a new profile for assignment to the user. The
    specified profile name must be the name of an existing profile.

    NOPROFILE is the default behavior and indicates that no special
    restrictions are applied to this user.

5  –  PUBLIC

    Explicitly creates a PUBLIC security profile entry in the
    database.

6  –  username

    The name of the user to add to the database. This must match the
    name of an existing OpenVMS username.
Close Help