1 Reply Latest reply on Jun 15, 2018 9:28 AM by Scott Dickinson

    Postgres data for Content Permissions and Project Hierarchy

    Scott Dickinson

      I am trying to build out a dashboard so we can tell a few things from Postgres

       

      1 - Project hierarchy - How to tell if a project is a subfolder, and which project it is under, and if its 1,2,3,etc.. levels down.

       

      2 - How to tell if the permissions are locked at the project level or unlocked.

       

      Can someone tell me which tables these are in, and which tables(s) I may need to join?

      We want to incorporate this with out permissions level by security group/project/workbook views.

       

      Thanks,

       

      Scott