I am migrating my IFS 10 database from Oracle 12G to 19C using the export import method (along with other steps to convert the database). After migrating the database to a new server, I ran the “Prepare Database” step from the IFS Build on the new application server. After that process completes (without any errors), I am trying to do a simple query from the database:
Select * from customer_info as the IFSAPP user. When doing this, I receive an ORA-01031: Insufficient privileges error.
Any idea what the issue might be?