Tuesday, May 1, 2012

export van fine grain acces control tables


I was migrating an database from Oracle 10gr2 to 11gr2
Using datapump.
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;

1 comment: