SQL Anywhere supports the following Adaptive Server Enterprise system procedures for managing users and groups.
|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 © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|