Question about Database Security profile

Hello,

I have an entity "Product" with 3 parents in the same level (Activity, Agency and Society)

---> Activity

Product ---> Agency

---> Society

Each user has access to one society, (To achieve that, I Filtered on the entity "Society" in the database security).

However Every user should have access to all members of the entities "Activity" and "Agency" even if he doesn't have products that are related to this members.

Is it possibl#e to achieve that in the database security profile ?

Thanks

any help would be appreciated.

Best regards

Ahmed Lattali

Find more posts tagged with

Accepted answers

All comments

Alexander Kappes

Dear Ahmed Lattali,

thanks for your request.

It is not possible doing such because of the relationship idea BOARD implemented.

When you select one Society, BOARD is doing the following:

1. depending to your select it looks for all related Products

2. depending to the products the other aggregations (Agency and Activity) are selected.

When the user didn´t have products related to a special Agency or Acitivity the element isn´t visible for him.

For sure you can solve using Dummy Elements inside your product to see all Agencies and Activities but in my opinion it doesn´t really make sense.

Hope it helps

regards

Alexander Kappes

LATTALI AHMED

Dear Alexander Kappes,

Thanks for your reply,

In my opinion, I think it makes sense depending on the business. If we say for example, next year a society "A" will start selling new products that belong to Activity "C" for the first time. These new products are going to be created in Board directly because they don't exist in their ERP.

When a society "A" user creates a product using ATO pager he/she will not have the possibility to choose Activity "C".

Dummy Products seem to be the only way to achieve that.

Thanks Alexander again for your help,

Best regards

Ahmed Lattali