Maintaining Sample Databases

The sample databases contain a guest user option that allows authorized users to access the database. Guest users have a wide range of privileges, including permissions to select, insert, update, and delete user tables.

We recommend that you remove the guest user option from user databases in production systems. 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 he or she is not confused by other users’ changes.
If space is a problem, instruct users to issue the begin transaction command before updating a sample database.
After users have finished updating one of the sample databases, instruct them to issue the rollback transaction command to undo the changes.