Authenticating users

New users must be added from an existing connection. As all UltraLite databases are created with a default user ID of DBA and password sql, you must first connect as this user.

You cannot directly change a user ID. Instead, add the new user ID and delete the existing user ID. UltraLite supports a maximum of four user IDs for each UltraLite database.

See Authenticating users.

To add a user or change a password for an existing user

  1. Connect to the database using the user ID and password of an existing user.

  2. Grant user access to the database with the desired password using the ULConnection.GrantConnectTo method.

    This procedure is the same whether you are adding a new user or changing the password of an existing user.

    See ULConnection class.

To delete an existing user

  1. Connect to the database using the user ID and password of an existing user.

  2. Delete an existing user using the Connection.RevokeConnectFrom method.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0