Hi, I need help to create a user that will be able to connect to the database via ODBC, but will only have access to read some table. I dont want to connect to the database as a super user. When I created my user, with permission let say just so he will be able to read the customer file, when I try to connect , it returns me an permission denied. What kind of rights I have to give this user so I can connect and yet have only permission to read table.
Have you given your ODBC user permission to : Object Type = system Object ID = 9130 Object Name = C/ODBC with at least Read = Yes ?
Thank you peter it works