I have a Navision 5.0/sql 2008 setup with users authentication with windows credentials. All users have full read/write access to the database.
Is there a way to prevent Navision users from making an ODBC and update data directly in the database, without using the Navision frontend?
I know I can setup a read-only user to select data only, but as I understand Navision need the windows users to be set up with full access. There is no authentication through Navision. Please correct me if wrong.