The same command can also be used to add a new user. For this reason, if you inadvertently enter the user ID of an existing user when you mean to add a new user, you are actually changing the password of the existing user. You do not receive a warning because this behavior is considered normal. This behavior differs from
To avoid this situation, use the system procedures sp_addlogin and sp_adduser to add users. These procedures give you an error if you try to add an existing user ID, as in Adaptive Server Enterprise, and
9.5.12 Dropping users may delete tables
The following warning should be added to “Revoking user permissions” in
Chapter 10, “Managing User IDs and Permissions” in Adaptive Server IQ
Administration and Performance Guide, and to the REVOKE statement in
Adaptive Server IQ Reference.
Warning! If you revoke a user's connect privileges, any database objects owned by that user are deleted without warning. Likewise, if you use the stored procedure sp_dropuser to drop a user, database objects owned by that user are dropped without warning. To avoid this problem, remove objects owned by a user or assign them to another user before issuing REVOKE CONNECT or sp_dropuser.
Note Procedures like sp_dropuser provide minimal compatibility with Adaptive Server Enterprise stored procedures. If you are accustomed to Adaptive Server Enterprise (or Adaptive Server IQ 11.x) stored procedures, you should compare their text with Adaptive Server IQ 12 procedures before using the procedure in dbisql. To compare, use the command
sp_helptext sp_name_in_question
9.5.13 Documentation on Data Backup and Recovery
The chapter on backup and data recovery in the Adaptive Server Anywhere User’s Guide has been superseded by new information in Chapter 11, “Backup and Data Recovery” of the Adaptive Server IQ Administration and Performance Guide. The Adaptive Server Anywhere data backup and recovery information should not be used.
45