I was migrating an database from Oracle 10gr2 to 11gr2
When using the expdp for exporting some schema’s I got the following error
ORA-39181: Only partial table data may be exported due to fine grain access control on "SFD4_OWN"."Info655_TAB"
To export tables with fine grain acces control you have to grant
The following role to the user you use for the export
EXEMPT ACCESS POLICY
Fine grid acces control also called row level security.
Is that you can only see the columns you are allowed to see
Or only some data but not all in such a column
SQL> grant EXEMPT ACCESS POLICY to migusr;