Maintaining the sample databases

The sample databases include a “guest” user login that allows access to the database by any authorized Adaptive Server user. The “guest” login has been given a wide range of privileges in pubs2 and pubs3, including permissions to select, insert, update, and delete user tables. See Chapter 3, “Managing Adaptive Server Logins and Database Users,” in the Security Administration Guide.

The size of the pubs2 and pubs3 databases are determined by the size of the logical page size for your server; 2, 4, 8, and 16K. If possible, give each new user a clean copy of pubs2 and pubs3 so that she or he is not confused by other users’ changes. To place pubs2 or pubs3 on a specific database device, edit the installation script before installing the database.

If space is a problem, instruct users 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.