This content has been marked as final. Show 4 replies
can anybody answer this question?
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?