sql2k5 security



Hi all, I am having an issue with SQL2K5 security. Here is my setup.

Tables

dbo.Table1
dbo.Table2
dbo.Table3

Roles

db_web

Users

webuser - member of db_web

Schemas

myschema - Execute/Select/Insert/Delete permissions given to db_web role.

Stored Procedures

myschema.dosomething

When I login as webuser and execute myschema.dosomething I get a permissions
error saying I do not have select and insert permissions on dbo.Table1

Essentially, I would like to shield all access by webuser to executing
stored procedures and views only and let the stored procs fetch/insert the
data from the base tables. This is considered good security for web apps.

How do I accomplish this?

TIA!



.