Maintaining Sample Databases

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

The sample databases contain a guest user that allows access to the database by any authorized Cluster Edition 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

Created June 23, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com