Northwind Traders Sample

External Views

Customers and visitors from outside the company should only be allowed to see public information and information that is directly relevant to them. We've used a variety of SQL Server features to provide a view of the database that does just that. Customers can update their profile, view their order history, search for products and place new orders all without exposing information about other customers or other sensitive information. Gatsby Database Explorer provides an interface that is customized for each user based upon their specific privileges.

Customer Privileges

Let's launch Gatsby Database Explorer and login as the customer "Maria_Anders" with no password. Be sure to exit Gatsby Database Explorer using the exit button (the little "x" in the Gatsby Database Explorer title bar) so that you are logged out properly.

Launch Gatsby Database Explorer

Northwind Traders Online Web Site

If you need a more customized presentation of the database for your customers, you can embed Gatsby Database Explorer lists and forms directly into your Active Server Pages using the Gatsby Application Objects. This technique allows you to build highly customized database applications with just a small amount of basic programming.

When you first visit the site you'll be able to browse the products as a guest. When you try to access a feature that requires more privileges you'll be asked to login as a customer. Again, login as "Maria_Anders".

Guest Privileges

Visit the Northwind Traders Online Web Site

The amount of custom ASP code required to build this site is minimal and is simple enough that even the most novice programmers can build highly interactive database applications for the Web without the huge learning curve associated with other solutions.

Next we'll see how the database looks to the employees of the company.

Go To Using