Windows Forum

Ask something
Discussion Locked

Microsoft Navision setup

0 helpful
4 replies

by clemejun

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am looking at a system running Navision Application. I am not really looking to go in deep but i just need to know how role assignment for users work. Can users be grouped? I also need to know how the administrative and superuser roles work - how much canone do with these "powers". Finally, I would liketo know what structures it uses to maintain data (database or flat file?),as well as how to go into the data tables outside of going via the application itself.

4 replies

by saguthrie

Navision can utilize either SQL Server for its database or it can use a proprietary database structure based in c\side -- a proprietary language that Navision was written in. A c\side database consists of a single structured file. Several tools are available for accessing data including an ODBC driver as well as a tool called C/Front. Security is controlled through the definition of users and roles. Users can be either based on Windows active directory or specific to Navision. Each user can be assigned one or more role. Roles define access to tables. There currently is no field level security. A special role called "Super" allows full access to all tables.

by saguthrie

Unless things have changed, native Navision does not offer field level security. Various third parties (Lanham, Cost Controls are two) offer "field level security" add-ons but it is not clear if these would protect someone from accessing the database via ODBC or C/Front.

This discussion is closed to new replies.