Missing ACLs resolve privilege after migration to 18c

Feb 7, 2019 6:25AM

Hello all,

after migrating a database 11.2.0.4 to 18c, I noticed that the "resolve" privileges on the custom ACLs were missing.

BEFORE migration (database 11.2.0.4):

SQL> SELECT acl,

2 principal,

3 privilege,

4 is_grant,

5 TO_CHAR(start_date, 'DD-MON-YYYY') AS start_date,

6 TO_CHAR(end_date, 'DD-MON-YYYY') AS end_date

7 FROM dba_network_acl_privileges;

ACL PRINCIPAL PRIVILEGE IS_GRANT START_DATE END_DATE

-------------------------------------------------- -------------------- ---------- -------------------- -------------------- --------------------

/sys/acls/mailserver_acl.xml TAS2 connect true

/sys/acls/mailserver_acl.xml TAS2 resolve true

/sys/acls/mailserver_acl.xml WITS connect true

/sys/acls/mailserver_acl.xml WITS resolve true

/sys/acls/mailserver_acl.xml ADMDATA connect true

Database Administration (MOSC)