Jack and Pat
drawbridgej at sympatico.ca
Mon May 10 13:08:20 CDT 2010
Brad, I'm not a sql server dba or user, but I found this after seeing the discussion with Rocky. http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/6da145a8-2d66- 4d8b-b584-4bbfcfa5408c Hope it's useful. jack -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Monday, May 10, 2010 2:00 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 "Read Only" access to SQL Server 2005 Rocky, Yes, that will probably work, but I was thinking that it would be nice to have the "read only" restriction controlled centrally. That is why I was interested if others had used "db_datareader" to learn if that would do the trick. Thanks, Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Monday, May 10, 2010 11:56 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007 "Read Only" access to SQL Server 2005 Will setting the form properties Allow Additions, Allow Deletions, Allow Edits to false do it? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Monday, May 10, 2010 9:27 AM To: accessd at databaseadvisors.com Subject: [AccessD] Access 2007 "Read Only" access to SQL Server 2005 Background. Client = Small firm, no IT Staff, no DBA, purchased package that uses SQL Server 2005. Client wants to use Access 2007 to link to the tables in SQL Server in order to create reports (via ODBC). I have DB2 experience, but only limited experience with SQL Server (especially in the security area). What is the best way to ensure that no one working with Access will ever be able to update any of the tables on SQL Server? All users will be able to see all of the data in all of the tables, we just cannot allow any updating of data in the SQL Server tables. I have read about a SQL Server "Fixed Database Role" called "db_datareader" Is the use of db_datareader the best route to go? Is there info on the web on how to set up and use db_datareader (or can someone here explain the steps) Thanks, Brad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2864 - Release Date: 05/10/10 02:26:00