SQL Anywhere 12 & 16
I start the database server and databases like this (for SA12):
dbsrv12 -n SERV part1.db part2.db part3.db
I want part2 and part3 to have access to some of the tables in part1
If I start sybase central and connect to part1 and try to grant the tables to part2 and part3
Grant select on part1.testtable to part2
Then I get an error messages stating
IF I remove part1 then it complaints about part2
If I do the same in SA16 then I get the error message
So I am obviously doing something wrong, but I do not know what...
SQL Anywhere does not allow direct access to other databases from the database that you are connected to. So in your case if you are connected to part1 then you do not have direct access to part2 and part3 databases.
To access the part2 and part3 databases when connected to part1 database you can use Remote Data Services (aka OMNI aka CIS aka Proxy Tables). Basically you need to create a 'proxy' table within Part1 that points to the tables in Part2 and Part3. Refer to the documentation for more information or post another question on this forum if you have specific questions.
answered 25 Nov '13, 09:30