Maintaining the sample databases – Sybase 15.0.2 User Manual
Page 62
Installing sample databases
48
Adaptive Server Enterprise
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.
Note
Sybase recommends that you remove the guest user from user databases
in production systems.
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.