Handle sql-server permissions gracefully with Navision -

background

I'm in the process of creating an application (referred to as MyApp ) Anyone who should read Navision managed by a SQL Server database, should use the Navision users to access their applications, without modifying the permissions in the database.

Permissions are looked at Navision's handling application layer, it checks permissions without having them stored in the database.

Problem

In the navision database, when users, permissions and other related objects overwrite, synchronizes to the database, then the general approach of creating a DB user and just using that Do not

Possible Solutions

I think the most appropriate solution would be MyApp in the Active Directory role, which gives the required permissions on DB, and this role is all Combines users.

I do not know how to do it, or even if it is possible, other solutions, or proposals are welcome, but please only suggest suggestions that are available for active directory or navigation. Can be managed from the inside.

The server is a SQL Server 2008 server running on November 5, and Customer Navigation is 6. I am using Active Directory for Windows Server 2K8.

Edit:

My app is a crate that needs to be edited to design and design applications and to read customer names and IDs, And there are some items in the table of items, and therefore I need this functionality

itemprop Generally, excluding the NAV layer and reading the DB directly / Write is not recommended at all, because you bypassing all NAV trading logic Who are deposited in the table and report the items in the NAV.

What does your app intend to do (if you can not find a specific, a broad stroke) and it would be possible to use a NAV add-in or dataport?