I would like to know if MlitiMaster Replication supports the VPD(Virtual Private Database) Row level or column level access control? if so could some one point me to the right documentation? i searched Metalink and googled but unable to find any info regarding the support of VPD to replication.
I'm not sure that I understand exactly what you are asking.
Are you trying to replicate data regardless of the VPD policy? Or only the data that is allowed by the VPD policy? What is the VPD policy defined on? The Oracle user? An application user? Something else?
we have streams and replication in our environment. our databases on window 2003 server and oracle 10gR2. my question is we are planning to implement the VPD on few tables which are already in replication group. We use 'REPADMIN' for replication. will it propagate the data for VPD columns that are in replication environment? how will this impact performance wise? I am trying to find also some Pros and Cons too.
OK, are you saying that you are using both Streams and materialized views to replicate data?
Are the policies going to allow the REPADMIN user to see all the data? Or is REPADMIN going to be granted EXEMPT ACCESS POLICY to bypass the VPD policy?