Just wondering, does it work like this or how can I achieve this
if a nav users does not have permission to read a particular table
he should not be able to read that sql table from outside as well
We have excel connectivity which read sql directly and users can read all the tables.
even they do not have permission into Navision.
Any advise please?