ALTER USER

    Table of contents

    ALTER USER applies a change to existing database users. Only existing superusers or the user itself have the priviledge to alter an existing database user.

    The name by which the user is identified inside the database.

    Changes a user parameter to a different value. The following user_parameter are supported to alter an existing user account:

    The password as cleartext entered as string literal.

    NULL removes the password from the user.

    Caution

    Passwords cannot be set for the crate superuser.