I have two user groups in the database (SQL Anywhere 12). One is default dba group and other is "group1". When I connect with the database using the Sybase Central with dba username in ODBC, I can edit the data of all tables including the tables which belong to group1. So no any problem with the Sybase Central.
However when I connect to database using same ODBC profile with InfoMaker, the dba user cannot edit the tables of group1. It can only edit the tables which belong to dba user. I still cannot edit the group1 tables even if I connect with group1 user in the InfoMaker.
What could be possible wrong with the group1 permissions? Why does Sybase Central allows to edit but not the InfoMaker?
The group "group1" is has following authorities:
and it has Memberships: DBA Public.
Thanks for any help.
asked 18 Sep '13, 04:38
Do you have a primary keys on your group1.table?
If I recall correctly .. Infomaker requires a priamary key in order for the table to be updatable.
answered 18 Sep '13, 08:40