Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Post-upgrade action after migrating to 11gR2 : Check ACL (Access Control List)

edited Apr 15, 2016 5:02AM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered

Hi

After migrating to 11gR2, I would like to know if it is mandatory to check ACL by executing the following procedure :

>>

DECLARE

acl_path VARCHAR2(4000);

BEGIN

SELECT acl INTO acl_path FROM dba_network_acls

WHERE host = 'host_name' AND lower_port IS NULL AND upper_port IS NULL;

IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(acl_path,'principal','privilege') IS NULL THEN

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl_path,'principal', is_grant, 'privilege');

END IF;

EXCEPTION

WHEN no_data_found THEN

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('ACL_name.xml','ACL description', 'principal', is_grant,

'privilege');

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('ACL_name.xml','host_name');

Tagged:

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