Database Administration (MOSC)

MOSC Banner

how does ACL migration from 12.1.0 to 19C work

migration was done via expdp/impdp and schemas,

now i want to get the ACL's from source (12.1.0.2) and migrate in 19C db (target)

I get the ACL's with this script. (on source)

and execute output:

SQL> exec dbms_network_acl_admin.create_acl(acl=>'NETWORK_ACL_26AED81610D84A415AB48F2E297E',description=>'L_26AED81610D84A4190315AB48F2E297E',principal=>'T_USR',privilege=>'JDWP',is_grant=>true,start_date=>null,end_date=>null);

BEGIN dbms_network_acl_admin.create_acl(acl=>'NETWORK_ACL_26AED81610D84A0315AB48F2E297E',description=>'L_26AED81610D84A4190315AB48F2E297E',principal=>'T_USR',privilege=>'JDWP',is_grant=>true,start_date=>null,end_date=>null); END;

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center