We are using a ODBC connection to allow users to update and change some tables in our SQL Server 2008. However, it seems as though our permissions has changed on the server as they are not able to do this any more. Even with a simple select statement. We are using windows authentication and when I check with the ODBC connection it test out fine.
What permissions on the database should I be changing so that they can read, write, update, insert, alter sort of stuff. I've taken over this SQL server from someone else. We have a group with all of the users listed in it so I just need to change permissions for that group.
Also do you need to restart a service or something when you change permissions on the database for it to take affect?
This is the most difficult thing they would do:
INSERT INTO AR.GIS.DEMO (ID, GEOID, GEOTYPE, TITLE, UserName)
SELECT ID, GEOID, GEOTYPE, TITLE, UserName
FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0', 'dBase IV;HDR=NO;IMEX=2; DATABASE=\\MA000XVSQL07\GIS\', 'select * from [DEMO.dbf]') AS DEMO