We have upgraded from Vapp Identity Governance 14.1 to 14.2. Also the DB we are using is Oracle instead of MSSQL. We are checking for views in oracle DB that was present in MSSQL but not able to find any view in Oracle.
We had the business need to use the MSSQL query to get the report. For example:
SELECT [RoleName],[ResName1],[ResName2],[ResName3] FROM [ig_sdb].[dbo].[SAGE_LINKS_ROLE_RESOURCE_VIEW] WHERE RoleName like '%Disconnected%'
Now such queries to be used for Oracle DB. However, we are not seeing any views. Could you please help us to continue this business need using ORACLE DB.
IG: Vapp Identity Governance 14.2
Oracle: Oracle Database 12c Enterprise Edition Release 126.96.36.199.0 - 64bit Production
Release : 14.2
Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)