Hi guys I a complete newbie in oracle databases and I'm just curious about when you do an export datapump in schema mode, does it also exports grants?


Yes, it exports all the objects under that schema including GRANTS also.

| improve this answer | |

You're asking lots of datapump questions - I suggest that you read the documentation.

If you have the DATAPUMP_EXP_FULL_DATABASE role, then you can specify a list of schemas, optionally including the schema definitions themselves and also system privilege grants to those schemas.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.