Prevent access to company

MartinFK

Hi,

We have multiple Companies in our database (running 4.03 on SQL 2005)
Our users need reading and partly writing access to tables on multiple companies. So they have roles with a defined company (their main-company) and sometimes roles without any defined company.

User Role
A Role-1 CompanyXY
A Role-2

Goal:
User A should only access his main-company in the "Open Company" window.
This main company is defined in the "user setup" table.

What I tried:
a) Catch the company in Codeunit 1 and throw an error --> Error is thrown, but still the company is opened
b) Security filter on table 20000006 --> no effect

Any further ideas to prevent them opening a Company?

Thanks for your help,
Martin

jannestig

Set a new role per employee or grouped enmpoyees on table 2000000006 and filter for just the company/s they should have.