We have a financial application with a SQL backend. There is a users group for the application users that allows them to write/edit the data in the tables.
Now, ownership has come to me and wants me to allow a member of that application user group the ability to access the tables via ODBC and MS Access, but have read-only permissions on the tables. Every thing I've tried so far does not work. He still can edit the data in MS Access.