Customizing the SQL 7.0 database for ASP Web sites (2)

web| Data | database | User License for site assignment table

Now, let's create a table for the database. To do this, click on the Webpages database node and select New Table (建新 table) from the Action menu item to complete the Build dialog box. You must add at least one field before you save the table, but before you build the table, it's best to have a complete database design for Web data.

For the sample database, we set up a table named WebData. To assign permissions to each user, right-click on the table you just created, and select the Properties menu item on the shortcut menu. From the Table Properties dialog, click Permission (permission permission) to bring up the Object Properties dialog box.

In this dialog box, assign the user the appropriate permissions so that the two Web users you just created can access the data in the database. For a Web server user, assign only select permissions to the logged-on user Iusr_earth It is in the sample database. Remember: The IUSR_servername user is the default Web server user. When a Web server can access a database without a user login, it actually accesses the database using the IUSR_servername user identity. For Web administrators, you can grant SELECT, INSERT, update, and delete permissions. These permissions provide webmaster with the capabilities required to create a web-based server management program.

As databases become more powerful and server technology progresses to the use of databases, database administrators need to know how to create databases and tables for the web. We have demonstrated a way to create and customize a database that is used on the web. Although there are other ways, this simple process can indeed meet the needs of most applications.