3 Replies Latest reply on Jun 5, 2008 5:19 PM by Yachera

    Row Level Security Materalized View

    Yachera
      I recently was trying to create a materialized view of a table that uses row level security. When trying to create it I was getting a:

      'ORA-28133: full table access is restricted by fine-grained security'

      I did some reading and found out that if I granted 'EXEMPT ACCESS POLICY' on both the schemas that were using the views I would be able to create them. That did work. The log works on the DB with the table and the view was created on the other DB, however there is no data showing up on the DB with the view. Is there something else I must do for this to work? Any help would be appreciated.

      Thanks