Hello All,I need to use DWH table in place of cmn_sec_assgnd_obj_perm_r_v where following fields are being used 1.object_instance_id
2.object_type = 'RECORD'
3.object_code = 'PRJ_PROJECT'
4. permission_code = 'ProjectViewManagement'
5.component_code = 'PRJ'when i try to get security based tables in DWH , i found these 2 tables regarding Security on Investment and Resource, but these have only permission_code = 'ProjectViewManagement' Column.DWH_INV_SECURITYDWH_RES_SECURITYCould you help me in suggesting table names.
All the DWH Security related tables start with "DWH_SEC". So, you can filter for tables starting with those words in your Database and query them.
I have run this Query to fetch tables which is like DWH_SEC.
select * from tab where tname like '%DWH_SEC%';There are no such tables which starts with DWH_SEC.
We have it documented, see the below
Release 15.1 Updates (SaaS) - CA PPM SaaS - 15.1 - CA Technologies Documentation
Those tables are available for 14.4 and 15.1. If you are below 14.4, the tables that you have mentioned are the only options, in addition to the Views mentioned in Suman's screenshot above.