NAV vs SQL Permission

ajayjainajayjain Member Posts: 119
edited 2014-03-21 in SQL General
Hi,

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?

Thanks
Ajay
Ajay Jain
UK

Comments

Sign In or Register to comment.