Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite SQL reference » UltraLite SQL statements

ALTER USER statement [UltraLite]

Alters user settings.

Syntax 1
ALTER USER user-name [ IDENTIFIED BY password ]
Parameters
  • user-name

    The name of the user.
  • IDENTIFIED BY clause

    The password for the user.
Remarks

If you use this statement in a procedure, do not specify the password (IDENTIFIED BY clause) as a string literal because the definition of the procedure is visible in the SYSPROCEDURE system view. For security purposes, specify the password using a variable that is declared outside of the procedure definition.

  • User IDs cannot:

    • begin with white space, single quotes, or double quotes
    • end with white space
    • contain semicolons

  • Passwords are case-sensitive and they cannot:

    • begin with white space, single quotes, or double quotes
    • end with white space
    • contain semicolons
    • be longer than 255 bytes in length
Side effects

None.

Example

The following alters a user named SQLTester. The password is set to "welcome".

ALTER USER SQLTester IDENTIFIED BY welcome