UltraLite.NET User's Guide

Understanding UltraLite.NET Development

User authentication

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. Instead, you add a user and delete an existing user. A maximum of four user IDs are permitted for each UltraLite database.

For more information, see User authentication in UltraLite.

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

1. Connect to the database as a user with DBA authority.

2. Grant the 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.

   For more information, see ULConnection class (iAnywhere.Data.UltraLite namespace) or Connection class (iAnywhere.UltraLite namespace).

To delete an existing user

1. Connect to the database as a user with DBA authority.

2. Revoke the user's connection authority using the Connection.RevokeConnectFrom method.

SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.