sql2k5 security
- From: <param@xxxxxxxxxxxxxxxx>
- Date: Fri, 16 Jun 2006 15:47:26 -0500
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!
.
- Follow-Ups:
- Re: sql2k5 security
- From: David Browne
- Re: sql2k5 security
- Prev by Date: Re: Server instances and limiting connectivity
- Next by Date: Re: sql2k5 security
- Previous by thread: Re: Server instances and limiting connectivity
- Next by thread: Re: sql2k5 security
- Index(es):