There are some differences between the Adaptive Server Enterprise and SQL Anywhere models of users and groups.
In Adaptive Server Enterprise, users connect to a server. Each user requires a login ID and password to the server and a user ID for each database they want to access on that server. Each user of a database can only be a member of one group.
In SQL Anywhere, users connect directly to a database and do not require a separate login ID to the database server. Instead, each user receives a user ID and password on a database so they can use that database. Users can be members of many groups, and group hierarchies are allowed.
Both servers support groups, so you can grant permissions to many users at one time. However, there are differences in the specifics of groups in the two servers. For example, Adaptive Server Enterprise allows each user to be a member of only one group, while SQL Anywhere has no such restriction. You should compare the documentation on users and groups in the two products for specific information.
Both Adaptive Server Enterprise and SQL Anywhere have a public group, for defining default permissions. Every user automatically becomes a member of the public group.
SQL Anywhere supports the following Adaptive Server Enterprise system procedures for managing users and groups. See Adaptive Server Enterprise system and catalog procedures.
|sp_addlogin||In Adaptive Server Enterprise, this adds a user to the server. In SQL Anywhere, this adds a user to a database.|
|sp_adduser||In Adaptive Server Enterprise and SQL Anywhere, this adds a user to a database. While this is a distinct task from sp_addlogin in Adaptive Server Enterprise, in SQL Anywhere, they are the same.|
|sp_addgroup||Adds a group to a database.|
|sp_changegroup||Adds a user to a group, or moves a user from one group to another.|
|sp_droplogin||In Adaptive Server Enterprise, removes a user from the server. In SQL Anywhere, removes a user from the database.|
|sp_dropuser||Removes a user from the database.|
|sp_dropgroup||Removes a group from the database.|
In Adaptive Server Enterprise, login IDs are server-wide. In SQL Anywhere, users belong to individual databases.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|