Maintaining Sample Databases

Sybase recommends that you remove the "guest" user option from user databases in production systems.

The sample databases contain a guest user option that allows access to the database by any authorized user. The guest user has a wide range of privileges, including permissions to select, insert, update, and delete user tables. For more information about the guest user and a list of guest permissions, see the System Administration Guide.

  1. If possible, and if space allows, give each new user a clean copy of the sample databases so that she or he is not confused by other users’ changes.
  2. If space is a problem, instruct the user to issue the begin transaction command before updating a sample database.
  3. After the user has finished updating one of the sample databases, he or she can issue the rollback transaction command to undo the changes.
Parent topic: Postinstallation Tasks