Hi Muhammad,
Would you give more information about your architecture ? What version of EntrepriseOne do you use ?
And indeed, you should be more precise about what you mean by "security", because this cover several things.
I'm talking about Xe, because i don't know if it still the same in earlier version, but security is mainly with the following tables :
- F00950, where are stored application security, row exit security, action security, row security, ...
- F0092, where are stored users and groups
- F98OWSEC, where are stored user passwords
In E1 xE standard, they're all tables from SYS7333.
Personnaly, i've already used different F00950 tables for 2 environments, mainly for security set up testing.
In that case, you need to create (generate through OMW) another table in a different datasource, and then add OCM Mappings for the environment you want to separate.
Except the fact you have to always be careful where you are when you make security change, something you must be aware of is that in web client (at least if using websphere), if you allow to connect to several environments from the same WAS node (which is possible even if not really recommended), the security table used will always be the one set up for the "default environment" (defined in the jas.ini of the WAS). So if you set up a different security table for let's say PY7333 environment, and the default environment of your WAS in DV7333, it won't use the security table you expected.
About F98OWSEC, never tried to use different ones with different environments (i mean except if you have different environments in seperate platforms with their own set of Data dictionnary, System tables, ...), and honestly, don't really see in what way it could be useful.
Is this any help ?
Regards,