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
Connect to the database using the user ID and password of an existing user.
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.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|