Expand all | Collapse all

What is this table odfsec_project_v ?

Jump to Best Answer
  • 1.  What is this table odfsec_project_v ?

    Posted 08-27-2018 10:40 AM

    I just found few records and this View and has just 1 column "User_ID", anyone please let me know if this is OOTB View ?




  • 2.  Re: What is this table odfsec_project_v ?
    Best Answer

    Posted 08-27-2018 11:27 AM

    Hi Santosh, 


    First of all, let me tell you that this is a view that related to Security of Project object.


    ODFSEC_PROJECT_V is a view that list down the Internal IDs of all the resources that have the access to the projects. 

    Basically, as much I as know, it is a less efficient version of ODFSEC_PROJECT_V2, which list down the user_Ids along with the project IDs on which it has access. So if an user A has access to 10 projects, you will find 10 rows for that User in ODFSEC_PROJECT_V2 view, one for each of the projects. 


    On the other hand, ODFSEC_PROJECT_V view will not have any USER_IDs repeating twice, as far as I know. Hope this helps. You can do some further research on this, using these information as something to start with.  


    Hope this helped to clarify the doubt you had. Cheers, buddy!


    - Abhisek Dhar