4 Replies Latest reply: Oct 1, 2013 9:55 AM by sfrade RSS

    impdp exclude some table grants

    sfrade

      Hi,

       

      I exported a schema containing tables. Each table has grants provided to other schemas.

       

      for example:

      the schema CSFDS_BAR grants SELECT, INSERT, UPDATE, DELETE on the table EXAMPLE to the schema CSFDS_FOO

      and SELECT on the same table to the schema QUX.


      I would like to import the datapump to another schema: ERHPQ_BAR; and remap the grants of the table EXAMPLE of CSFDS_FOO to ERHPQ_FOO but exclude the grant provided to QUX.


      I use the following parameters to remap the schemas.

      SCHEMAS=CSFDS_BAR
      
      EXCLUDE=USER,SYSTEM_GRANT,ROLE_GRANT,DEFAULT_ROLE,TABLESPACE_QUOTA
      REMAP_SCHEMA=CSFDS_BAR:ERHPQ_BAR
      REMAP_SCHEMA=CSFDS_FOO:ERHPQ_FOO
      

       

      Grants to CSFDS_FOO are correctly remap to ERHPQ_FOO. But I haven't a way to exclude the grants to QUX.

      I tried EXCLUDE=OBJECT_GRANT:"GRANTEE in ('QUX')" but failed.

       

      Please advice.

       

      Sebastien