Limiting users of ODBC to read only access

[petertickler]

I want to set up an ODBC link to a SQL Server database for a user, but want to ensure he can see, but NOT update, the tables.

Is there a way of doing this within the ODBC, or do I have to do it within the permissions of SQL Server.

Peter Tickler

 

[zemp]

I would set up a user on the database with the permissions that I want and then have the ODBC DSN use that specific user and password to log into the database.

zemp