UltraLite databases can define up to four user IDs. UltraLite databases are created with a default user ID and password of DBA and sql, respectively. All connections to an UltraLite database must supply a user ID and password. Password changes and user ID additions and deletions can be performed once a connection is established.
You cannot directly change a user ID. You can add a user ID and delete an existing user ID.
You can use SQL statements to authenticate users as an alternative to using the UltraLite C API. See CREATE USER statement.
♦ To add a user or change a password for an existing userConnect to the database as an existing user.
Grant the user connection authority with the desired password using the conn->GrantConnectTo method.
This procedure is the same whether you are adding a new user or changing the password of an existing user. See GrantConnectTo method.
♦ To delete an existing userConnect to the database as an existing user.
Revoke the user's connection authority using the conn->RevokeConnectFrom method.
 |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |