C/ODBC and Permissions

tonyduea

Hi. I have a client that wants to give me read only permission to connect through C/ODBC using SQL Server to copy table data. She has given me read and execute permission on all of the tables that I need to read. But I still can't connect (No Permission) unless I use an account with full permission.

I have no knowledge of Navision and no access to the security except through the client, so any guidance with what we are forgetting would be appreciated.

I've set the DSN to read-only to try to give them some protection, but a readonly account would be safer.

Thanks,

McLean

Tony,
You also need Execute permission on the System table 9130 C/odbc. Have you been given this?
Regards
Angus