Hi,
We create db installation containers for our service, that of which use Liquibase to install/migrate specific db schemas. These db installation contains have admin scripts, and user scripts. The admin scripts are there to (initially) create the desired service db user, and (later) to potentially make modifications to it - e.g. add new grants/privileges. The user scripts are there to create, well ahum, user objects.
My ask is about the admin scripts, and in particular granting execute privileges on dbms_cq_notification. In ADB-S this works, because over there our db installer performs the admin part, using the ADMIN account for the PDB. However, for Oracle23ai Free I have yet to find out which account to use. I cannot use the SYSTEM account, because that cannot grant execute on the respective package, and I also cannot run the liquibase script using the SYS account - which gets denied by Liquibase itself. We use Oracle23ai Free for multiple things, amongst others verification of these db installation containers, and I would love to also be able to verify this part.
So question: what are my options to accomplish this?