Maintaining the Sample Databases

The sample databases include a “guest” user login that allows access to the database by any authorized SAP ASE user.

The “guest” login has a wide range of privileges in pubs2 and pubs3, including permissions to select, insert, update, and delete user tables. See Security Administration Guide > Managing SAP ASE Logins and Database Users.

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.