This discussion is archived
4 Replies Latest reply: Oct 1, 2013 7:55 AM by sfrade RSS

impdp exclude some table grants

sfrade Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points