Stuart McLachlan
stuart at lexacorp.com.pg
Sun Jan 9 23:15:28 CST 2011
I don't expect the same results in Access :-) The query is Read Only, the problem is with your display interface. The SSMS interface doesn't retreive any information about the R/W status of the data that its displaying so it doesn't stop you from modify the *displayed* data. Access forms are smarter and lock the displayed data if it is RO. -- Stuart On 10 Jan 2011 at 0:07, jwcolby wrote: > I created two users to test the rights I assigned and how they > function, straight in SQL Server. One is read and one is read and > write. > > The read / write operates as expected, however the read only allowed > me to modify but not save the modifications. Somehow I expected the > query to be readonly. > > Again this was directly in a SQL Server table, logged in to SSMS > through that user. > > I expect the same results once I get to getting at the data from > Access. Is there a way to prevent even the appearance of modifying > the data if the user is read only? > > -- > John W. Colby > www.ColbyConsulting.com > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >