Maintaining the sample databases

The sample databases contain a “guest” user that allows access to the database by any authorized Adaptive Server 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.

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.

If space is a problem, you can instruct the user to issue the begin transaction command before updating a sample database. After the user has finished updating one of the sample databases, he or she can issue the rollback transaction command to undo the changes.