Database Utilities (MOSC)

MOSC Banner

Datapump and ACLs

in Database Utilities (MOSC) 1 commentAnswered ✓

Oracle 19C.

Schema needs to be exported and imported to another database. Schema owner has network ACL privileges. All datapump offers is INCLUDE=NETWORK_ACL which exports/imports ACLs and privileges granted on ACLs. Issue is INCLUDE=NETWORK_ACL can be used with full export only. And it is understandable from ACL point of view since ACL is database level object. But privileges granted on ACLs are schema level. And unfortunately Oracle doesn't include schema ACL privileges with schema export by default and offers no INCLUDE for it. So we are forced to write own (easy task, but nevertheless) code to script out user ACL privileges and

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center