I have a user that needs to do queries on an SQL Server 2008 database that I administrate. They have rights to edit the data, but I'd rather they weren't able to do it directly against the table (i.e., I'd prefer they'd use the application that they were given).

What I'd like to do is give them a Read Only ODBC connection, and hang an MS Access MDB/ACCDB off of it, and let them query to their heart's content without accidentally "updating" data.

Is there a way to do this, or am I stuck having to create a RO user for them to use, and then threaten them with much pain if they connect using their regular RW account? In which case why not threaten them with much pain for editing data outside of the application?

  • 1
    I don't know if there's such a thing as "read-only ODBC connection", but it seems to me you could just create a database user with SELECT rights only. – Andriy M Aug 1 '12 at 19:30
  1. Create a user in SQL Server with only the perms you want them to have.
  2. Set up the user ODBC string to use this credential
  3. Profit :)

Create a user and give only read-permissions to him

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.