SQL Server View needs permission on underlying tabel

From: lars (cld_at_stratek.se)
Date: 06/29/04


Date: Tue, 29 Jun 2004 01:27:01 -0700

Hello!

I need to set UPDATE permission on a view without setting UPDATE permission on the underlying table. I have read that this should be possible but it does not work in my Access 2002 project using ADO connections. Why? I use SQL Server 2000 and ADO version 2.7.

/Lars