After migrating a regular database to Oracle Autonomous database and removing the DBA role granted to the user, when browsing in the schema browser, there are ORA-00942 errors when just clicking on the tables.
From the Spool SQL it is possible to grant roles individually, but even with SELECT ANY DICTIONARY granted on this user, which should cover all these permissions, this doesn't prevent the 'ORA-00942 Table or View does not exist' error.
In the documentation for Oracle Autonomous Database, the following is mentioned:
==================
Roles and Views Restrictions for Data Dictionary
Granting SELECT ANY DICTIONARY does not provide access to the SYS/SYSTEM schemas.
You can grant SELECT_CATALOG_ROLE to allow SELECT privileges on all data dictionary views, if needed.
https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/autonomous-sql-commands.html
==================
As a next step, please try granting the SELECT_CATALOG_ROLE. *Make sure it's a default role.
GRANT "SELECT_CATALOG_ROLE" TO ABC;
ALTER USER ABC DEFAULT ROLE ALL;
If Toad is connected when this statement is run, please reconnect after running it and it should fix the issue.
