Re: Help pls: Not allow users access to tables, stored procedures only
- From: "David Browne" <davidbaxterbrowne no potted meat@xxxxxxxxxxx>
- Date: Tue, 13 Jun 2006 13:02:50 -0500
"Ben" <ben_1_ AT hotmail DOT com> wrote in message news:60FD4599-B496-4C65-A863-8D8ADD8D72E9@xxxxxxxxxxxxxxxx
Hello
I have created a database where all the functionality (add, delete, select,
update, etc) is performed via stored procedures. The front end (ASP.NET
application) runs the stored procedures. The problem we have run into is
that when we set up a role for ALL users to have which ONLY has exec
permissions on the stored procedures, we get errors saying we dont have the
correct permission for select permission on the tables. We have been able to
set this up before on other apps, and for the life of us, cannot figure it
out for this one. All the db settings look the same but the stored
procedures see to requir the users to also have select permission on the
tables.
Check out Ownership Chains in BOL. http://msdn2.microsoft.com/en-us/library/ms188676.aspx
Granting execute on a proc will supress permission checks on objects owned by the owner of the procedure.
Probably you do not have intact ownership chains from the procedures to the tables.
David
.
- Prev by Date: Re: Setting up Linked server to MsAccess
- Next by Date: Re: Bug in MSKB918992 ("How to transfer the logins...") - How to report?
- Previous by thread: Re: Column Encryption via stored procedure
- Next by thread: Re: Help pls: Not allow users access to tables, stored procedures
- Index(es):
Relevant Pages
|
