Company security on a report

m.gretener

I have different companies in Navision 3.7. One of them is the holding to which none of the normal users have access. Through a report I want to enable users to view some information from that company via CHANGECOMPANY. How can I make this work without giving the different users access to the Company.

With kind regards,
Marc G.

kriki

If I am not mistaken, if a user uses that report and a CHANGECOMPANY happens to a table in a company he is NOT allowed to see, he will get an error. But to be sure, you have to test it.

m.gretener

Yes, I already tested this. There is an error because the user has no rights to the other company. But how can I enable the report to run, without enabling security rights for the user to the other company?

Is this for example possible by something like:
Get UserId.
Userid becomes Administrator
run report
change userid to former UserId

or is there a simpler solution; function?

Marije_Brummel

Have you tried to change the permissions on the report? Does this override the permissions in the user setup?

If this does not work, the only solution is to give (indirect) rights to the other company.

davmac1

If you are running the SQL Server version, you can create a view in the one company that provides the allowable data from the other company and provide permissions to the Navision table linked to that view.

kriki

Give the users a role with Indirect-read permissions in the tables which the report uses. In the report, you give permission to read those tables.So the users can never access the table directly, but the report can do it (=indirect permission).