Re: Grant v Deny
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 24 Jun 2008 15:29:41 -0700
AHartman (Hoosbruin@xxxxxxxxxxxx) writes:
I set this as described but when the user who was in the secret list
connected using ODBC and ACCESS to link the table that couldn't make any
changes to the table content.
Could not use view or function because of binding errors (#4413)
Well, you did not say how the users accessed the database, so how
could I know?
Not that I know that much how linked tables in Access and that works.
The only hint I can give an SQL Server person, is to set up a Profiler
trace and see what Access emits. Else I think you need to take your
new problem to an Access forum where they may have experience of that
error message (which clearly comes from Access.)
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Grant v Deny
- From: AHartman
- Re: Grant v Deny
- From: Erland Sommarskog
- Re: Grant v Deny
- From: AHartman
- Re: Grant v Deny
- From: AHartman
- Grant v Deny
- Prev by Date: Re: Server roles
- Next by Date: Re: Server roles
- Previous by thread: Re: Grant v Deny
- Next by thread: Server roles
- Index(es):
Relevant Pages
|
