Clarity

 View Only
  • 1.  Which table in DWH replicates cmn_sec_assgnd_obj_perm_r_v

    Posted Nov 02, 2016 02:18 AM

    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_SECURITY
    DWH_RES_SECURITY

    Could you help me in suggesting table names.




  • 2.  Re: Which table in DWH replicates cmn_sec_assgnd_obj_perm_r_v

    Posted Nov 02, 2016 02:34 AM

    Hi,

     

    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.



  • 3.  Re: Which table in DWH replicates cmn_sec_assgnd_obj_perm_r_v

    Posted Nov 02, 2016 03:11 AM

    Hello,

     

    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.



  • 4.  Re: Which table in DWH replicates cmn_sec_assgnd_obj_perm_r_v

    Broadcom Employee
    Posted Nov 02, 2016 03:20 AM

    HI Santosh,


    We have it documented, see the below 

     

    Release 15.1 Updates (SaaS) - CA PPM SaaS - 15.1 - CA Technologies Documentation 

     

     

    Regards

    Suman Pramanik



  • 5.  Re: Which table in DWH replicates cmn_sec_assgnd_obj_perm_r_v

    Posted Nov 02, 2016 03:41 AM

    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.