Djabarov, Robert
Robert.Djabarov at usaa.com
Fri May 16 08:46:51 CDT 2003
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