Hi to everybody, I found a situation ever met before. I develop on Dynamics NAV 5.01 and I have developed a method to be able to see some particular tables of an external database. In substance it deals with a property of tables of Dynamics NAV. When I
create a table in NAV, I can create it in 3 different ways: table common to all the companies table for company or table linked to a view.
This last case is mine, on the same db of NAV I have created a view with some fields, I have created in NAV a table linked with equal fields and types. Until here all normal.
The view, however, aims to another database that doesn't center anything with NAV but that it is on the same intance of SQL server.
The consumer that accesses NAV is a consumer type database SQL Server and has the permitted db_public and db_datareader on both the database. Then he can read the views on the db of nav both on the db of the other database.
When it tries to enter from the console of sql server, with the consumer database, all it works, if I do it by NAV, it show me an error "The server principal "username" is not able to access the database "some_database_name" under the current security context.
(Microsoft SQL Server, Error: 916) "
If I add on the database NAV to the consumer, the role db_owner,
View Complete Post