New users have to be added from an existing connection. As all UltraLite databases are created with a default user ID and password of DBA and sql, respectively, you must first connect as this initial user.
You cannot change a user ID: you add a user and delete an existing user. A maximum of four user IDs are permitted for each UltraLite database.
For more information about granting or revoking connection authority, see grantConnectTo method and revokeConnectFrom method.
Connect to the database as an existing user.
Grant the user connection authority with the desired password.
conn.grantConnectTo("Robert", "newPassword"); |
Connect to the database as an existing user.
Revoke the user's connection authority as follows.
conn.revokeConnectFrom("Robert"); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |