User license for allocation tables
Now, let's create the table of the database. The operation is: click on the WEBPAGES database node, select New Table from the Action menu item, and complete the Create New Table dialog box. At least one field should be added before saving the table, but before building the table, it is best to have a complete database design for web data.
For the sample database, we created a table called WEBDATA. In order 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 to bring up the Object Properties dialog box.
In this dialog, assign the user the appropriate permissions so that the two web users just created can access the data in the database. For web server users, only SELECT permission is assigned to the logged-in user IUSR_EARTH in the sample database. Remember: The IUSR_ServerName user is the default web server user. When the web server can access the database without user login, it actually uses the IUSR_ServerName user identity to access the database. For web administrators, SELECT, INSERT, UPDATE, and DELETE permissions can be granted. These permissions provide Webmaster with the ability to create a web-based server hypervisor.
As databases become more and more powerful and server technology has advanced to the point where databases can be leveraged, database administrators need to know how to create databases and tables for the web. We have demonstrated a way to create and customize databases used on the web. Although there are other methods, this simple process can indeed meet the needs of most applications.