[dba-SQLServer]Security Permissions on Views

Perhaps he is referring to a problem with ADP's using views and the tables 
not having permissions.  See pages 124 and 130 of "MS Access Developer's 
Guide to SQL Server" (Chipman and Baron).

Regards

David Emerson
DALYN Software Ltd
25b Cunliffe St, Johnsonville
Wellington, New Zealand
Ph/Fax (877) 456-1205

At 16/05/2003, you wrote:
>Are your vendor rep's eyes brown?  They ought to be, because he is full of 
>it :)   Never heard of that bug and can assure you it does not exist!  But 
>give us more details, maybe I am missing something...Also, give us the 
>name of the vendor :)
>
>Robert Djabarov
>Senior SQL Server DBA
>USAA IT/DBMS
>? (210) 913-3148 - phone
>? (210) 753-3148 - pager
>
>
>  -----Original Message-----
>From:   Stoker, Kenneth E [mailto:Kenneth.Stoker at pnl.gov]
>Sent:   Thursday, May 15, 2003 5:14 PM
>To:     dba-SQLServer (E-mail)
>Subject:        [dba-SQLServer]Security Permissions on Views
>
>We recently implemented a system trying to implement security at the view 
>level.  Upon deploying, it was discovered that security at the view level 
>appeared to have no relevance.  We ended up having to set permissions on 
>the tables themselves.  The vendor of the application stated that there 
>was a bug in SQL Server that M$ had not fixed yet such that the 
>permissions on view didn't work.  Is this true?
>
>Ken Stoker
>Technology Commercialization
>Information Systems Administrator
>PH: (509) 375-3758
>FAX: (509) 375-6731
>E-mail:  Kenneth.Stoker at pnl.gov
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com