it’s been a while since my last post. So, I wanted to write about export and import ACL privileges. They always become a pain (at least for me). after 12c, Oracle introduce us a new and easy way of ACL copying from db to db. export&import.
so here is the basic command on your source database:
this will export all stored ACL privileges on your database and to import those ACLs to a new db:
so easy but during the import you can get ORA-24244: invalid host or port for access control list (ACL) assignment error.
I encountered this error while creating a new db for a client. In my case this has happened because RESOLVE privileges shouldn’t be used with port definition!
so, somehow previous db has port definitions for RESOLVE privileges and those ones wasn’t imported. to add them into new db, I simply used this sql:
run this select on the source db and execute the output on the target db.
wish you all happy and healthy days.