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.
K. Brian Kelley