SQL$HELP72.HLB  —  ALTER  USER  Arguments

1  –  ACCOUNT 

    Syntax options:

    ACCOUNT LOCK | ACCOUNT UNLOCK

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

2  –  COMMENT_IS 

    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 and replaces
    any previously assigned profile. The specified profile name must
    be the name of an existing profile.

    NOPROFILE removes any assigned profile from the user. No error is
    returned if a profile is not currently assigned.

5  –  PUBLIC 

    The PUBLIC user in the database. This entry gives you control
    over anonymous users who access the database.

6  –  RENAME_TO 

    Changes the user name and, if a security profile exists, assigns
    the security profile associated with the old user name to the new
    user name. This might be used, for example, when a person's name
    changes (as through marriage), and, therefore, his or her account
    on the operating system is changed accordingly. The new-username
    must not currently exist in the database.

    When the ALTER USER command is issued, the existing user name is
    removed from the database and replaced with the new-username. If
    SECURITY CHECKING is INTERNAL, then subsequent SHOW PROTECTION
    statements will display the new name for the user, and all GRANT
    and REVOKE statements will require the new-username. The new-
    username is not visible to other sessions until the transaction
    containing the ALTER USER command is committed.

    See the RENAME for further discussion.

7  –  username 

    An existing user name in the database.
Close Help