ORA-39181: Only partial table data may be exported due to fine grain access control


ORA-39181: Only partial table data may be exported due to fine grain access control

. . exported "APEX_030200"."WWV_FLOW_CLICKTHRU_LOG_NUMBER$" 4.914 KB 1 rows
. . exported "APEX_030200"."WWV_FLOW_COMPANIES" 5.625 KB 3 rows
. . exported "KOCAZER"."CPM_PACKAGE_DEPOSIT_RATES" 5.734 KB 4 rows
ORA-39181: Only partial table data may be exported due to fine grain access control on "KOCAZER"."USERS"

the weird thing that VPD is not enabled to show this error but once i grant the system the required privileges the error stop appearing in the logs.

grant EXEMPT ACCESS POLICY to anar;

---------

To avoid this:

Grant the privilege EXEMPT ACCESS POLICY to the exporting user

-or-

Disable the VPD policy.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: