Maintaining the sample databases – Sybase 15.0.2 User Manual

Page 62

Advertising
background image

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.

Advertising