You are on SQL Server 2005, right? If so, first:

- Create a role. You can do this through SQL Server Management Studio's GUI.

- Make the ASPNET user account a member of the role. Again, you can do this through the GUI.

- Are all the objects in the same schema (such as dbo)? If so, you can GRANT *Permission* ON SCHEMA::*SchemaName* TO *Role* (you will need to open up a query window for that).

- If all access is through stored procedures (preferred from a security perspective), you only need to grant EXECUTE as the permission.

- If, however, the application makes direct access to tables and views, you will need to grant SELECT, INSERT, UPDATE, and DELETE. The shortcut for that is to grant ALL as the permission.