ORA-39181: Only partial table data may be exported due to fine grain access control on “SYSMAN”.”EM_SU_ENTITIES

I have been running an export on our Development Grid Control (Cloud control 12c R3) , which is running 11.2.0.3 version of the database running on Linux(Red Hat).   After the upgrade, the VPD has been placed on many SYSMAN tables.  

ORA-39181:Only Partial Table Data Exported Due To Fine Grain Access Control

I use the “SYSTEM” user and it appears that the system user is not able to export full data of these tables due to vpd policies enabled.

To Check the dba_policies

select object_name from dba_policies where object_owner=’SYSMAN’;

OBJECT_NAME

SSA_ZONE_OBJECTS

SSA_SERVICE_TEMPLATES

SSA_REQUESTS

MGMT_TEMPLATES

MGMT_SWLIB_ENTITY_REVISIONS

MGMT_OMS_PROPERTY_DEF

MGMT_JOB

MGMT_IP_REPORT_DEF

MGMT_CORRECTIVE_ACTION

MGMT_CM_CHANGE_PLANS

GC_MANAGEABLE_ENTITIES

EM_TEMPLATE_COLLECTIONS

EM_TAAS_TEST_DRV

EM_TAAS_TEST

EM_TAAS_ENVIRONMENT

EM_TAAS_ASSET

EM_SU_ENTITIES

EM_RULE_SETS

EM_PPC_POLICY_GROUPS

EM_PPC_POLICIES

EM_PC_PLANS

EM_PAF_LATEST_PROCEDURES

EM_NC_CREDS

EM_MEXT_GROUPS

EM_MANAGEABLE_ENTITIES

EM_ISSUES_INTERNAL

EM_EVENT_SEQUENCES

EM_COMPLIANCE_GROUP

EMCT_TARGETS

DB_HA_CONFIG

DB_HA_BACKUP_REPORT

 Solution :

 

In order to avoid this error,we have to grant EXEMPT ACCESS POLICY to the exporting user(in our case user:system) and restart export.Database users granted the EXEMPT ACCESS POLICY privilege, either directly or through a database role, are exempt from VPD enforcements.

grant EXEMPT ACCESS POLICY to SYSTEM;

Once completed, the error was resolved .

 

 

Advertisements

2 thoughts on “ORA-39181: Only partial table data may be exported due to fine grain access control on “SYSMAN”.”EM_SU_ENTITIES

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