Patient Database

This is the home page for the DrOffice application. To use this application the DrOffice database must first have been created using the scripts that came with the book. Assign a system DSN with the name DROfficeDB to the database.

Five commands can be executed from this home page. They are described below:

Manual Login

This command permits you to chose the login ID to be used when retrieving data from the database. The user ID is used to retrieve the user's role from the database. The role is used to determine the category of data that the user is permitted to retrieve from the database.

Integrated Login

This command uses the context of the current user as the user ID. To make this work create four users with the IDs Peter, Paul, Mary, and Pat to test this out. Assign each user to a role in the Authorization Store DrOffice.xml using the Authorization Manager MMC which you can access by running AzMan from the Run dialog or the command line.

Application Tables

This command is used to look at the application tables that are used to define the users who are part of the staff along with their role, the data category that each role can access, the value for each data category, and the data category for each column in the patient table.

Add Patient Record

This command permits you to add a new record into the Patients table. Play with the role values and the category values for the database columns to see how it affects the output. You can modify the data category for the database columns by using the SQL Query Analyzer tool and right-clicking on a column and selecting Extended properties. Change the value of the DataCategory property and see how it affects the output.

Submit Resume

This command permits you to submit a new resume to the database. Multiple data blocks can be added to each resume entry. Each data block can be assigned a data category. When viewing the resumes, the reviewer will only be able to see those fieds that match his or her role.

Manual Login

Integrated Login

Application Tables

Add Patient Record

Submit Resume