What is the best way to do Row Security

[Rauf]

We are setting up new companies in the same environment. What is the best way to do Row Security on CO.

We have general roles as follows:-
FINMGR
AP
AR

So if we go for new two companies, we will have the below roles.

1. FINMGR
2. AP
3. AR
4. FINMGR_CO02
5. AP_CO02
6. AR_CO02
7. FINMGR_CO07
8. AP_CO07
9. AR_CO07

I am thinking another approach which I read somewhere in the web ( which minimise the number of roles)

Create two new roles for Row Security as follows:

1. CO02_Sec
2. CO07_Sec
3. FINMGR
4. AP
5. AR

and apply all the security on the above roles. And attach the users to the corresponding roles. So the nine roles minimised to five roles.

This security will work if the user select *ALL in the roles selection screen. But it will not work if the user select a specific role.

JDEList geeks have to add their thoughts to the above approach.