i am getting the following error for a new user table. although i have added it to the user role and synchronize.
"The following sql server errors occured while accessing the xx table.
1088, “42000” Microsoft ODBC sql server driver. Cannot find object. xx because it does not exist or you do not have permissions.
SQL:
SEt identity_insert xxx ON
( here xx is the table name)
Are you trying to create the table xx or just access the table xx?
Anyways i guess this problem is related to db_owner privileges.
this is when user is accessing it.
i dont see any issue with db_owner privileges. as same user can access other tables.
hmmm…actually i faced this same problem long time ago. The same user can access one table and cannot access the other., although he has every permissions and the table is under his licence too. What i did is i created again the table and it was working. I don’t know if you want to try the same.